error #1045 - Access denied for user 'root'@'localhost' in phpmyadmin

Question

phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in your configuration and make sure that they correspond to the information given by the administrator of the MySQL server.

Even after uninstalling wamp and then reinstalling it's showing the same error.

Isaac Bennetch · Accepted Answer · 2015-09-05 02:29:58Z

1

You can try connecting via the command-line interface using the username and password you expect; if that doesn't work then I presume you'll need to reset your password.

The MySQL manual has detailed instructions for resetting a lost root password.

Generically, those instructions are:

Start MySQL with the --skip-grant-tables option
Connect via the command line client with mysql (or the Start Menu program that corresponds to the command line client).
Run FLUSH PRIVILEGES to load the privilege table
Reset the password with a command like SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPass'); adjusting the username, host, and password as needed.
Stop and re-start the MySQL server.

answered Sep 5, 2015 at 2:29

Isaac Bennetch

12.5k2 gold badges37 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

error #1045 - Access denied for user 'root'@'localhost' in phpmyadmin

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related