Page 1 of 1

MySQL won't work after restart

PostPosted: 29. April 2009 10:00
by iwarlord
I'm using the latest version of Xampp for windows on Vista Business 64bit and having problems with mysql.
Setting up a root user with no password works fine during installation, but after a computer restart I cannot connect anymore. I use phpMyAdmin and get the error #1045 - Access denied for user 'pma'@'localhost' (using password: NO) . I've tried editing the config file to use the "root" user settings but no luck; have tried setting up different users with and without passwords but nothing works after a restart.
I can't even connect via command prompt so it's not a phpMyAdmin error.

Any ideas what I'm doing wrong?

Cheers,
Chris.

Re: MySQL won't work after restart

PostPosted: 30. April 2009 22:10
by FeralReason
I had the same problem. In the (probably C:\)xampp\mysql folder there are 3 batch files:

mysql_uninstallservice
mysql_installservice
resetroot

If I remember correctly, I ran all 3 of these in this sequence and it solved my problem. I suspect that the resetroot alone might do it. Let me know if this works !

Glenn