Page 1 of 1

Error 1045

PostPosted: 19. February 2011 23:32
by KhaosDiem
Hey guys i'm just wondering whats going on with my PHPMYadmin because it's not letting me on. Whenever I go into PHPMYadmin this shows up.

Error
MySQL said:

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

Connection for controluser as defined in your configuration failed.
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.

Does anybody know how to fix this?
Thanks!

-KD

Re: Error 1045

PostPosted: 20. February 2011 06:06
by xfsgpr
This indicates that you have entered an incorrect password. You need to try to remeber the correct password or try this:

# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('your_new_password') where USER='root';
mysql> FLUSH PRIVILEGES;

However, you might have stored a text file somewhere on your mysql installation which contains your password. I suggest try to find that file using *.txt. This will only workk if you answered Yes at the time of installation to store the password.

hth