Cannot Create Windows Service for MySQL. Error:0
You've installed MySQL on a Windows Virtual Private Server and when tried to start it, you've received following error messages:
"Error: Cannot create Windows service for MySql. Error: 0" during the configuration part of the MySQL install.
"ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)" when you try to run mysql from the command line when the MySQL service isn't running.
"Error 1067: The process terminated unexpectedly" when trying to start the MySQL service.What you need to do is to open command line (Start -> Run -> cmd) and type the following:
sc delete mysqlYou should receive a message like this:[SC] DeleteService SUCCESSThen uninstall MySQL completely using "Add or Remove Programs". After it has been uninstalled, install it again using installation wizard. When it ends, don't choose to configure MySQL right away, instead just uncheck the box and click OK.Open command line (Start -> Run -> cmd) and type this:
C:\Installation_Path\mysqld.exe --install MySQL41 --defaults-file="C:\Installation_Path\my.ini"Where 'Installation_Path' is the location where you've installed MySQL initially - make sure to write the path correctly. Note: 'MySQL41' is the name of the MySQL service and it needs to be different than 'MySQL'.Hit enter and restart your Windows VPS. MySQL should be running fine now. If you continue to experience this problem, please contact our Support Department.
__________________Milovan Milic
