phpmyadmin can't access mysql after changing localhost PW
Posted: 08. March 2012 00:45
Hello, I'm having problems opening phpmyadmin after I attempted to change the mysql password.
What I did to change it was to go to the privilages tab in phpmyadmin, and changed the password for root/localuser. As soon as I did that, I could no longer access phpmyadmin. I get the following error.
" MySQL said:
Cannot connect: invalid settings.
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 tried uninstalling XAMPP and reinstalling, but I still get this error. The samples under PHP in the XAMPP panel work fine, so I think mysql is running with no problems.
I checked the C:\xampp\phpMyAdmin\config.inc.php file, and there is no password set there, which is the default setting.
This was working fine before I tried to change the password. What do I need to reset to get this to work again?
Also, what all do I need to set to simply add a password for mysql database?
What I did to change it was to go to the privilages tab in phpmyadmin, and changed the password for root/localuser. As soon as I did that, I could no longer access phpmyadmin. I get the following error.
" MySQL said:
Cannot connect: invalid settings.
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 tried uninstalling XAMPP and reinstalling, but I still get this error. The samples under PHP in the XAMPP panel work fine, so I think mysql is running with no problems.
I checked the C:\xampp\phpMyAdmin\config.inc.php file, and there is no password set there, which is the default setting.
This was working fine before I tried to change the password. What do I need to reset to get this to work again?
Also, what all do I need to set to simply add a password for mysql database?