Re: Cant get MySQL started on XP

[Paul Jackson]

I think you need to reset the root password. I don't know what the default root password is, but I would set it to null initially. See section A.4.1 of the users manual for how to do this.

Here are a few cryptic notes i have....
Test mysqlshow:
Create DOS prompt
cd mysql\bin
mysqlshow
mysqlshow –u root mysql
Note: This command will fail if the root password is not ‘’

Reset root password:
Create file c:\mysql-init.txt containing one line:
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('');
<Make sure MySql Services stopped. Check task manager processes to make sure mysqlld-nt is not running. Last resort power-off power-on pc with service on manual startp-up to make sure mysql is not running. >
Create new DOS window
cd \
C:\FoxServ\mysql\bin\mysqld-nt --init-file=C:\mysql-init.txt
kill this DOS window after it appears to hang.
Restart the MySql service.

Repeat mysqlshow test:
Create new DOS window
C:\FoxServ\mysql\bin\mysqlshow
C:\FoxServ\mysql\bin\mysqlshow -u root mysql // This works if the root password gets reset.