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:
[SC] DeleteService SUCCESS
Then 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:
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.
- "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.
- sc delete mysql
[SC] DeleteService SUCCESS
Then 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"
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
Milovan Milic