I've put the password in the main phpmyadmin and not one of the databases. How can I even access it if can't even have the chance to input the password.
Asked
Active
Viewed 1.4k times
3 Answers
4
Take a look at reseting the MySQL root password here.
UPDATE mysql.user SET Password=PASSWORD('MyNewPass') WHERE User='root';
FLUSH PRIVILEGES;

Yada
- 30,349
- 24
- 103
- 144
-
1Yes, you can use a blank password but don't do it. – Jesse Weigert Feb 06 '10 at 02:42
-
1It's working. I created Password for phpmyadmin WAMPservser2.4 in FF. To revert that password to root user to empty this commnad working for me. – gnganapath Oct 22 '13 at 07:31
1
First check if you assigned empty password. There is a high probability not to assign password when you install locally.

nerkn
- 1,867
- 1
- 20
- 36