Cannot create Windows Service for MySQL.Error:0
I was installing MySQL on a Windows 2008 64bits machine today. The installation went smooth as usual, I got the MySQL configuration screen wizard at the end of the MySQL installation and went through filling in those service configuration details, MySQL root ..etc. However, at the end of the execution part where it writes the changes, it shows the following message during the attempt to start the MySQL services.
Cannot create Windows Service for MySQL.Error:0
It was my first time getting this message as I have been setting up MySQL for lots of Windows server without any issues on the past. Here’s what I did to get it resolve:
1. Start > All Programs >MySQL > MySQL Server 5.x > MySQL Server Instance Config Wizard.
2. Hit the Next and select the options “Remove Instance” and complete the process.
3. Fire up the MySQL Server Instance Config again, this time select the Configure Instance with Standard Configuration and go through the setup again. It should get your MySQL configured again.
The possible cause of the error is due to the MySQL Services has been installed and started on your server’s prior to the configuration by MySQL. Removing the installed instances and reset it up will help to resolve this.
Thanks a lot, worked like a charm and saved me hours of frustration! =)
Omg man! It worked! Thanks alot. I’ve been setup alot of MySQL on both Windows Server and Linux server at my company but never run into this problem.
Thanks!! It worked for me!
Thank You
thanks.. men… work this methods
Looks like half of People listed here with this Problem Failed to fix the Problem using this method. I am One of Those that this DID NOT work for.
Funny as the version MySQL Version 5.1.37 Essentials worked perfect in a previous install, only difference was the other install was Server 2008 Standard and this one Server 2008 Enterprise.
Anyone Please Help
And Post the Solution here for the other 50% of Posters
Regards
Colin
i’ve tried another solution without resource hacking.
After installation, I did not check both checkbox (for configuration & web site).
I’ve installed in c:\mysql & c:\mysql\data\data (little error on folder selection from me).
Then launch : MySQLInstanceConfig.exe
Starting service works (but not last state with error 1045)
Its Works..!.. thanks
but the error with the “Apply security Settings” >> I used W2k3 server with SP2 and MySQL 6
Thanks
It also works…
Thanks
Installing MYSQL5.1 for the first time. Installation fails and following instructions does not fix the problem when I delete the first and only instance of the installation. Service will NOT start. I thought this was supposed to be so easy? Even Windows Servers work the first time out. What is the issue here? Any ideas?
Installing on Vista Ultimate.
Thanks for this.
Problem not solved…Same problem occurring.