Server will not start (Windows)

from the Artful MySQL Tips List

If you can't see an error message, check the error log in your MySQL datadir folder ...

c:\documents and settings\all users\application data\mysql\mysql server MAJOR_VERSION_NUMBER\data\YOUR_MACHINE_NAME.err

where MAJOR_VERSION_NUMBER is your MySQL version number, 5.0, 5.1, or 5.5, and YOUR_MACHINE_NAME is, well, your machine name.

To correct settings errors reported in the above file, open ...

c:\program files\mysql\mysql server MAJOR_VERSION_NUMBER\my.ini

in your favourite text editor (recommended: NotePad++, TextPad, PSPad).

A shortcut to seeing server load errors is to run ...

c:\program files\mysql\mysql server MAJOR_VERSION_NUMBER\bin\mysqld --console

in a DOS window. The errors will be shown right there. Once it's running, open another DOS window and run ...

c:\program files\mysql\mysql server MAJOR_VERSION_NUMBER\bin\mysqladmin -uroot shutdown

then run

net start mysql

to start the MySQL service.

Return to the Artful MySQL Tips page