In this note,
<MYSQL_HOME> refers to the full path to your installation folder. Start the MySQL server in a DOS window with this command:
Beware two bugs. First, if you are running XP SP2, you may have to add
\bin\mysqld --defaults-file=" \my.ini" --console --skip-grant-tables
--skip-slave-startto that command, even if you have not set up replication! Second, to step round a long-unfixed MySQL server bug, always put the defaults-file argument first.
If the above command fails, you will see error messages, which is why you ran the command with the
--console option. Fix the errors and try again. Once you succeed, assuming InnoDB is enabled, MySQL will spit out several lines ending with something like this:
101127 21:35:22 InnoDB: 1.1.3 started; log sequence number 1532574764Note that it appears to hang (because the server is still running).
Now in another DOS window, try to connect to your server:
and attend to any errors that raises, if necessary following instructions under "Reset 'root' password".