WampServer

How do you set up a MySQL Password for root?
I can't access PhpMyAdmin.
Please, I need help!
Thank you!

Try working through this. [forum.wampserver.com]

Then if you still have a problem be a bit more specific about what is wrong

Having the same problem. Noticed a warning that I was set up to access MySQL with no password and that this was a potential weakness. In phpMyAdmin I (naively) went to the privileges section and added passwords for all users but then it locked me out of phpMyAdmin.

Specific error I am getting is:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

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.

I think I've assigned a password to user that's set to not use a password. Still trying to work it out.

It's common issue

U set the password for MySQL users

Now you must tell phpmyadmin the password to login

So open

C:\wamp\apps\phpmyadmin\config.inc.php

And add the root password to the password line.


You can delete all those other users in phpmyadmin except for

User = root
Host = localhost

Steven Martin
stevenmartin99@gmail.com
stevenmartin99@hotmail.com
PampServer.com - [pampserver.com]