When installing mysql5.1, the following error occurs: cannot create Windows Service for MySQL. Error: 0.

When installing MySql in Windows 7, "cannot create Windows Service for MySQL. Error: 0" appears ",

 

Generally, this problem is caused by a reinstallation of MySQL or an error in the configuration service. The solution is as follows:

1. Right-click my computer> Manage> services and applicationsProgram--> Service, locate the MySQL Service Startup item, and stop the service first.

2. Run the following command as an administrator:"SC Delete MySQL(MySQL is the service name, based on your service name )"

3. Uninstall the existing MySQL instance, delete the remaining MySQL files on the disk, and search for "MySQL ".

4. restart the system and reinstall mysql. The installation is successful!

 

To learn how to run the command line with administrator privileges, see: