Page 1 of 1

SOLVED Mysql: could not start the service MySQL. Error: 0

Posted: Thu Aug 06, 2009 9:57 pm
by Peter_w
Hi,

I get the following error when installing MySQL Server 5.1 in windows xp

Code: Select all

Could not start the service MySQL. Error: 0
I use the .msi file for installation.
OS is windows XP

Anyone has any idea what this error means?

Regards

Re: Mysql: ould not start the service MySQL. Error: 0

Posted: Thu Aug 06, 2009 10:17 pm
by Peter_w
When checking the windows log files,
I see a warning and several error messages for MySQL.

Warning: Plugin 'FEDERATED' is disabled.
Error: Plugin InnoDB init function returned error
Error: Plugin InnoDB registartion as a Storage Engine failed.
...

Re: Mysql: could not start the service MySQL. Error: 0

Posted: Thu Aug 06, 2009 10:54 pm
by Peter_w
Success

I did a uninstall of MySQL.
And then a new complete new install, with standaard settings,
BUT most important, without innoDB.

As it s for a local intranet site, i don't really need it.

Stopped the server

I copied all the data files to the directory I wanted.
Update the my.ini -file:

Code: Select all

#Path to the database root
#datadir="C:/Documents and Settings/All Users/Application Data/MySQL/MySQL Server 5.1/Data/"
datadir="E:/server/MySQL_data/"
Done.

I think there is somehow a problem with windows XP and the innDB system.