Re: Could not start the service MySQL. Error: 0

[Pavel Srubar]

The Setup Wizard for MySQL Server 5.1 allows to change the installation directory. I choose N:\MySQL, where I have more free space.
However, the room for data is by default created in All Users' application data directory. In my case it was
C:\Document and Settings\All Users\Data aplikací\MySQL\Data\.
Localized versions of Windows XP translate the %APPDATA% folder with non-ASCII characters, which MySQL seems not to be able to cope with.

After Setup Wizard had announced its famous message which gave name to this thread,
I manually edited N:\MySQL\my.ini and changed the section

#Path to the database root
datadir="N:/MySQL/data/"

Then I moved the data directory from All Users' Application data\MySQL\data to its new position N:\MySQL\data and succesfully started the MySQL service. No reinstalling necessary.



Edited 1 time(s). Last edit at 05/25/2009 08:27AM by Pavel Srubar.