Error: CannotcreateWindowsserviceforMySqlError: 0 _ MySQL

Error: CannotcreateWindowsserviceforMySqlError: 0 solution bitsCN.com
Error: Cannot create Windows service for MySql Error: 0 solution Error: Cannot create Windows service for MySql. Error: 0:

This problem occurs when you have not stopped and uninstalled an existing MySQL service and re-installed or upgraded MySQL using the MySQL Configuration Wizard. The reason is that when the Configuration Wizard tries to install the service, it finds that a service with the same name already exists. One solution to this problem is to use the configuration wizard to select a service name other than mysql. In this way, the new service can be correctly installed, but the original service is retained. But this is not good. it is best to unload old services that are no longer in use. To permanently uninstall the old MySQL service, you can run the following command on the command line: [plain] C:/> SC delete mysql. if SC is not available in Windows, you can download the delsrv tool from the SC tool and use the delsrvMySQL syntax. There are also some good methods on the Internet, as shown below: ① delete the mysql installation file on the control panel ② go to computer-service, stop mysql service ③ go to the directory you installed (drive C, drive D, etc.): 1. mysql installation directory, usually C:/Program Files. 2. mysql Data storage directory, which is generally in the C:/Documents and Settings/All Users/Application Data directory (note that the Application Data folder is hidden by default, you can choose tools> Folder Options> View> Show all files and folders to hide files ). 3. delete registry data and use regedit to delete the following files: reference HKEY_LOCAL_MACHINE/SYSTEM/ControlSet001/Services/Eventlog/Applications/MySQL HKEY_LOCAL_MACHINE/SYSTEM/ControlSet002/Services/Eventlog/Applications/MySQL HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Services/Eventlog/Applications/mysqlbitscn.