Troubleshooting MySQL Error: Cannot create Windows service for

Today's class to sum up some of the blog tips, which is more sense of achievement is how to achieve "title-category name-blog name", hehe! Then there are students chasing me to ask me MySQL installation problem, thanks to no class, or stuck, looking for a long time to find out how to solve the problem, MySQL Error: Cannot create Windows service for mysql.error:0

Installing the new MYSLQ database, installing the MySQL Server Instance Config Wizard, and finding that the service cannot start at the last step, this prompts "Cannot create Windows service for Mysql.error:0 "!

The workaround is as follows:

Reason:

Installing MySQL may produce cannot create Windows service for mysql.error:0 errors, most of the reason for the error is due to reinstalling MySQL or upgrading to MYDQL, using MySQL Configuration Wizard.

Workaround:

First stop the MySQL service:

You can use a service name other than MySQL, such as MYSQL11, and so on. But this is not the best solution and we can use Windows SC program to remove the MySQL service.

C:>SC Delete MySQL

[SC] DeleteService SUCCESS

And then reuse MySQL Configuration Wizard, there's no such mistake.

If it's still not working, restart the computer, OK.

I follow the above steps to operate, the result is still not, may be the actual situation is different.

Finally, I uninstalled the MySQL completely and then reinstalled it in a different directory to run successfully.

Although the method is stupid, but very effective, hehe.