Re: Cannot Create Windows Service for MySQL. Error:0

[Umesh Shastry]

Hi!

[From MySQL Docs]

Error: Cannot create Windows service for MySql. Error: 0

This error is encountered when you re-install or upgrade MySQL without first stopping and removing the existing MySQL service and install MySQL using the MySQL Configuration Wizard. This happens because when the Configuration Wizard tries to install the service it finds an existing service with the same name.

One solution to this problem is to choose a service name other than mysql when using the configuration wizard. This will allow the new service to be installed correctly, but leaves the outdated service in place. While this is harmless it is best to remove old services that are no longer in use.

To permanently remove the old mysql service, execute the following command as a user with administrative privileges, on the command-line:

C:\>sc delete mysql
[SC] DeleteService SUCCESS

Take a look at http://dev.mysql.com/doc/mysql/en/windows-troubleshooting.html


also this may happens when you have installed MyQL in the C:/Program Files/....
the space between Program & files also prevent from creating/starting service..
So install MySQL server in C:/ itself say C:/MYSQL


Hope This Helps!

Regards,
Umesh Shastry
http://www.blogger.com/profile/02551756983528645221