How to solve “Access denied for user 'phpmyadmin'@'localhost' (using password: YES)"

Question

mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)
The connection to the controluser as defined in your configuration has failed..

Solution

I know this post is old, but here is what happened to me. I was upgrading and the phpmyadmin installer asked what the phpmyadmin user password should be, or to leave it blank to random generate a password. I hit enter without entering any password by mistake. So when I launched PHPMyAdmin, I got the error "mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES)".

To fix it, I found the "config-db.php" file in /etc/phpmyadmin/ and got the password from there. Root access to PHPMyAdmin was working, so I logged in as root to PHPMyAdmin and used the query "SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD([copy and paste the password here])" and it worked!

Comments

[George Udosen]

Please kindly translate those text and copy and paste them into your question...

[islem GUESMI]

thx , but it does not work , againn i have the same error like : mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.

[sleepyhead]

mysqli is a php module to create a database connection over the network. you use the phpmyadmin user to connect to the database to create that user, or it does exist, but you don't have the correct password. So that's why I would use a terminal so that you can connect to the database to fix that problem. I now see that the command 'sudo mysql' dropped from my answer.

[islem GUESMI]

CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'phppassword'; ERROR 1396 (HY000): Operation CREATE USER failed for 'phpmyadmin'@'localhost'

[islem GUESMI]

mysql> CREATE USER 'phpmyadmin'@'localhost' IDENTIFIED BY 'password'; Query OK, 0 rows affected (0.00 sec) mysql> GRANT ALL PRIVILEGES ON . TO 'phpmyadmin'@'localhost' WITH GRANT OPTION; Query OK, 0 rows affected (0.00 sec) ES) mysqli_real_connect(): (HY000/1045): Access denied for user 'phpmyadmin'@'localhost' (using password: YES) La connexion au controluser tel que défini dans votre configuration a échoué.

[sleepyhead]

ERROR 1396 indicates that the user exists, to reset it's password run SET PASSWORD FOR 'phpmyadmin'@'localhost' = PASSWORD('supersecretpassword'); ... next you can do the GRANT PERMISSIONS and may be FLUSH PRIVILEGES;

[David]

I would go further referring to another answer in your answer is useless if the other answer were to be deleted. An answer should be complete in itself and if it is no different then an answer all ready given it has no value. If the answer is not complete simply make a comment to an existing answer,