"access denied" in phpmyadmin
Posted: 09. October 2006 23:27
I can't figure out what is going wrong here.
phpmyadmin always worked fine. the only change i made was changing the mysql password and then a bit later it started giving me access denied errors like this:
When I try to connect through the command line I get the following error:
Does anyone know what could be wrong?
Also I had Apache and php installed prior to installing xampp so maybe that could be a source of conflict somehow, although everything worked fine until i changed the password.
Thank you very much in advance.
phpmyadmin always worked fine. the only change i made was changing the mysql password and then a bit later it started giving me access denied errors like this:
- Code: Select all
Welcome to phpMyAdmin 2.8.2.4
phpMyAdmin tried to connect to the MySQL server, and the server rejected the connection. You should check the host, username and password in config.inc.php and make sure that they correspond to the information given by the administrator of the MySQL server.
Error
MySQL said: Documentation
Cannot connect: invalid settings.
When I try to connect through the command line I get the following error:
- Code: Select all
C:\Program Files\xampp\mysql\bin>mysql -uroot -p"mypassword"
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password:YES)
Does anyone know what could be wrong?
Also I had Apache and php installed prior to installing xampp so maybe that could be a source of conflict somehow, although everything worked fine until i changed the password.
Thank you very much in advance.