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

Locked
Peter_w
Posts: 28
Joined: Tue Aug 19, 2008 9:28 am

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

Post 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
Last edited by Peter_w on Thu Aug 06, 2009 10:54 pm, edited 1 time in total.
Peter_w
Posts: 28
Joined: Tue Aug 19, 2008 9:28 am

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

Post 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.
...
Peter_w
Posts: 28
Joined: Tue Aug 19, 2008 9:28 am

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

Post 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.
Locked