Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am trying to search a solution for this problem, but didn't find a solution. I am getting an error while login in phpmyadmin

#1045 Cannot log in to the MySQL server

Connection for controluser as defined in your configuration failed.

I am trying to configure config-db.php and config.inc.php files reside in /etc/phpmyadmin/ directory. There i am changing $dbname and $dbpass in config-db.php as my root user and password but still can't login. After google, i get some clue and uncommented a line in config.inc.php:

/* Uncomment the following to enable logging in to passwordless accounts,
     * after taking note of the associated security risks. */
    $cfg['Servers'][$i]['AllowNoPassword'] = TRUE;

These things are so ridiculous, follow articles like Lamp server installation shows step by step things and i do the same thing, but i get this error thrice times. Even i can't login in mysql through shell. Please help me to sort out this problem and know the actual reason why this happen when i am enter password twice time while installing mysql.

share|improve this question
    
i am redirected from stackoverflow to ask this question on superuser – shihon Jul 9 '12 at 17:45
    
With what account are you trying to log in? Can you log in with your root account? – Rhyuk Jul 9 '12 at 17:52
    
@Rhyuk: yes i am using my root account while setup during lamp server installation – shihon Jul 9 '12 at 17:55
    
Have you tried resetting your MySQL password? – Rhyuk Jul 9 '12 at 17:57
    
i am using only root account on my server – shihon Jul 9 '12 at 18:03
up vote 1 down vote accepted

Try changing your MySQL password:

To reset your mysqld password just follow these instructions :

  1. Start the mysql client process using this command

    mysql -u root

  2. From the mysql prompt execute this command to be able to change any password

    FLUSH PRIVILEGES;

  3. Then reset/update your password

    SET PASSWORD FOR root@'localhost' = PASSWORD('password');

  4. Once have received a message indicating a successful query (one or more rows affected), flush privileges:

    FLUSH PRIVILEGES;

  5. Then stop the mysqld process and relaunch it with the classical way:

    sudo /etc/init.d/mysql stop sudo /etc/init.d/mysql start

Source: https://help.ubuntu.com/community/MysqlPasswordReset

UPDATE:

Lets try updating your current password. Do this:

$ pkill mysql
$ sudo mysqld --skip-grant-privileges
$ mysql

At this point you get the mysql command shell. You will need to update the root password and flush the table when you reset the password.

mysql> set UPDATE mysql.user SET Password=PASSWORD('YOUR_NEW_PASSWORD') WHERE User='root';
mysql> FLUSH PRIVILEGES;

Now that you’ve flushed your passwords, just restart your mysql daemon.

$ sudo pkill mysqld
$ sudo /etc/init.d/mysqld start
$ mysql -u root -p
Enter Password: YOUR_NEW_PASSWORD
mysql>
share|improve this answer
    
I know the Source, but from shell i get the error after type mysql -u root: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO) – shihon Jul 9 '12 at 18:19
    
now get this error after doing mysql -u root: ERROR 1040 (HY000): Too many connections – shihon Jul 9 '12 at 18:26
    
Updated the answer. – Rhyuk Jul 9 '12 at 18:34
    
pkill mysql sudo mysqld --skip-grant-privileges, after these steps, mysql command gives ERROR 1040 (HY000): Too many connections – shihon Jul 9 '12 at 18:58
    
If you are reaching the max connection limit go to /etc/my.cnf and under the [mysqld] section add max_connections = 500 and restart MySQL.Then try to update your password again. – Rhyuk Jul 9 '12 at 19:12

Try password "mysql". Your mysql root and system login root passwords are not synchronized, you have to set each individually. Make sure you change the mysql root login!

share|improve this answer
    
i get this error ERROR 1040 (HY000): Too many connections after try password mysql and mine, but didnt work – shihon Jul 9 '12 at 18:41
    
Try resetting mysql with service mysql restart. Since default password didn't work, it sound like you'll have to skip-grant-privs as below. – SilverbackNet Jul 9 '12 at 18:44

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .