Access denied to for user root
Posted: 12. March 2010 13:54
I use xampp for local testing and have left the root mysql password as empty. This has suddenly started denying me permission to access it saying "Access denied for user 'root'@'localhost' (using password: NO)". I've tried resetting the password using resetroot.bat, but it fails with the following:
Note that I'm using WindowsXP, so I'm not surprised it can't find "\usr\local\mysql"! I don't know where it's getting that path from.
I've had this problem a few times before, and ended up reinstalling xampp to fix it. It works initially - and I can't find any pattern to what makes it suddenly stop working.
Thanks for any help with this,
Dan.
C:\xampp\mysql>resetroot
100312 12:44:43 [Warning] Can't create test file \usr\local\mysql\data\dan-pc.lower-test
100312 12:44:43 [Warning] Can't create test file \usr\local\mysql\data\dan-pc.lower-test
mysql\bin\mysqld.exe: Can't change dir to '\usr\local\\mysql\data\' (Errcode: 2)
100312 12:44:43 [ERROR] Aborting
100312 12:44:43 [Note] mysql\bin\mysqld.exe: Shutdown complete
Passwoerter fuer Benutzer "root" und "pma" wurden nicht geloescht!
Passwords for user "root" and "pma" were not deleted!
Press any key to continue . . .
Note that I'm using WindowsXP, so I'm not surprised it can't find "\usr\local\mysql"! I don't know where it's getting that path from.
I've had this problem a few times before, and ended up reinstalling xampp to fix it. It works initially - and I can't find any pattern to what makes it suddenly stop working.
Thanks for any help with this,
Dan.