Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
I'm experiencing the same issue on my machine.
Running a XAMPP distribution on Windows XP Professional.
The MySQL is available when starting the mysql server deamon using the following command line
mysqld-nt.exe --skip-grant-tables
However i cannot connect to it when using it in a normal mode. I subsequently get the connection error for 'root'@'localhost' (using password: yes). I also tried to reset the root password and trying to flush-privileges first.
Niether did help resolve the issue.
I also cannot connect to the deamon using the MySQLAdmin windows application. It does not give me the server name.
I tried modifying the include file by setting the host to localhost or 127.0.0.1, but to no avail. If i set the include file not to use HTPP authentication, but to 'config' and specify the 'root' user and the accompanying password (or blank password after reset), this also gives an error when starting the PHPMyAdmin application (wrong user/password).
Has anyone got any suggestions?
Thanx,
Ferry
Subject
Written By
Posted
September 02, 2007 11:00AM
Re: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
September 03, 2007 03:31AM
September 03, 2007 02:44PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.