Mar
11
164

Cannot create Windows Service for MySQL.Error:0

Author andy18    Category Windows-related     Tags

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.

164 Comments to “Cannot create Windows Service for MySQL.Error:0”

  • Simon Bailey March 30, 2009 at 9:50 am

    Thanks! What an amazing fix, so simple. It worked well for me, now to get around Error 1045 (password problems most likely…). :D

  • Simon Bailey March 30, 2009 at 9:52 am

    Oh, fixed that too by following your instructions on removing and re-adding the instance. Got the password correct this time and it is going without a hitch.

  • andy18 April 1, 2009 at 4:02 pm

    Nice to see it works well for you, Simon!

  • Susan Petracco April 5, 2009 at 12:01 am

    Worked well for me too, though I had to manually delete the server after running the remove option, by opening a cmd window running as administratory (this is on Vista) and then issuing the command:

    sc delete mysql

    Then I ran it again with the standard configuration and it worked fine, just like you said. Thanks!

  • amit April 5, 2009 at 2:35 pm

    It doesn’t worked for me…

  • Nick April 5, 2009 at 10:03 pm

    Thank you!

    The first few links on google were useless, you on the otherhand solved my problem.

  • Jack April 5, 2009 at 11:57 pm

    Thanks alot!

  • priya April 8, 2009 at 1:24 pm

    i could not find the remove instance option in the config wizard.

  • Erin April 9, 2009 at 3:17 am

    Just tried this…it didn’t work for me. The instructions were easy to follow, but when I went through the configuration wizard the second time, I got the error:0 again.

  • Bob Johnson April 9, 2009 at 10:22 pm

    Thanks! Worked for me. Nice easy fix.

  • red April 10, 2009 at 6:53 am

    no, not for me, please help me.

  • mark April 11, 2009 at 12:28 pm

    Thanks Andy! I have been looking for a solution, it was just so easy :)

  • paladin April 12, 2009 at 9:42 pm

    thanks alot. worked for me too. :D

  • tnylea April 15, 2009 at 9:01 am

    Didn’t work for me. I removed all instances, but I still got the error. Thank you though.

  • sara April 19, 2009 at 9:33 am

    It worked for me too!!! Thanks! After installing and uninstalling so many times… a simple solution that worked!!!

  • Martin April 19, 2009 at 10:33 am

    Did not work for me.

  • Hafz Alam April 20, 2009 at 2:46 am

    Thanks – trawling through the web got me nowhere until I found this solution.

    Thanks

  • dobbmay April 23, 2009 at 4:22 pm

    very nice. It works properly now

  • puya4ever April 26, 2009 at 6:32 pm

    it don’t worked for me…

  • Edogaru April 26, 2009 at 9:32 pm

    Es la mejor solucion que he encontrado.

    Gracias

  • mary April 28, 2009 at 11:10 pm

    Thanks a lot – works like a charm, been pulling my hairs out for 2 days until now.

  • mike April 29, 2009 at 7:43 am

    thanks – got mysql working at last!!!!!!!!!!!!! Its only taken a month.

  • Chris May 3, 2009 at 8:31 pm

    This worked for me on my local Windows Vista SP1, but not for my server running Windows Server 2003 SP2. I think there are some extra security issues on the server… not sure.

  • TC May 4, 2009 at 9:24 am

    You sir are a legend :)

    Thanks!

  • Satya May 6, 2009 at 9:19 am

    Thank you Sir!

    It has worked… Good that I did not follow other links and remove and reinstall it again… Thanks a LOT..

  • Jonathan Clemons May 11, 2009 at 7:49 pm

    THANKS!!!!!

  • yuri May 12, 2009 at 4:57 pm

    it didn’t worked :(
    how can I fix it? :(

  • Kelly May 13, 2009 at 3:32 am

    Thanks! It works for me.

  • rubel May 13, 2009 at 3:54 pm

    thanks,it works,but during configuration look at your version,then click.

  • Natasha May 14, 2009 at 5:27 pm

    Hi
    This didn’t work for me i went through the steps but still get the same error. Are there any other suggestions this is driving me mad and i need to get it.
    Thanks

  • jonny May 14, 2009 at 10:47 pm

    didnt work for me

  • Ryan Deschaine May 16, 2009 at 11:19 am

    OK. If you are having problems installing the latest 5.1 MySQL Server, install Version 4.1 Works perfectly ;)

  • Manish May 17, 2009 at 4:27 am

    Thnx Dude, It really Works :)

  • Eric May 18, 2009 at 3:06 am

    Unfortunately, it did not work for me…
    MySQL 5.1.34-win32 on Windows Vista.

    Previously had MySQL installed, did not realize it when I installed 5.1.33 later, now cannot work on this PC. I’ve tried searching for and removing all “mysql” items in RegEdit.

  • ue May 18, 2009 at 4:56 pm

    i followed the steps you told us and it works!

    i have tried to remove Instance during the Installing prozess, but it did not work. only when i went through “Start > All Programs >MySQL > MySQL Server 5.x > MySQL Server Instance Config Wizard ” and then chosed “remove Instance”l, it works! maybe there is something to do with the Registry….

  • Chris May 20, 2009 at 5:19 pm

    Worked a treat, and a lot cleaner and clearer than other suggestions posted on the web – many thanks.

  • Paper May 23, 2009 at 8:33 am

    got it working on windows vista ultimate X32. thanks a load!

  • Giovanna May 23, 2009 at 10:01 pm

    Andy,

    Thank you for posting, and thank you to Mary who posted this link! Worked like a charm after spending a couple of hours trying everything else!

  • Dave Nielsen May 24, 2009 at 4:41 pm

    Thank you mucho. I had uninstalled/reinstalled over 10 times. But this worked just as advertised. And so simple!!

  • rafaciber May 27, 2009 at 12:15 am

    It work for me! thanks ….

  • Justin May 28, 2009 at 6:31 am

    Genius!
    It worked and I have to say I’ve never used MySQL and have reinstalled a few times because I cannot get ODBC working and the forums haven’t helped but your advice was brilliant

  • techie May 28, 2009 at 9:44 pm

    Does NOT work!

  • es_binario May 29, 2009 at 4:03 am

    La solucion es muy facil, lo unico que tienen que hacer es editar todas los archivos .ini (exepto uno) y cambiar la “/” por “\” guardar los cambios y listo funciona a la perfeccion, subi un video a youtube. para los que todabia tengan el problema busquenlo como

    en youtube MySQL5 error: 0 Solucion, Solution

    The solution is too easy, the one thing that they have to do is to edit everything files .ini ( I without one ) and changing her to keep changes and I list it works to perfection, I got up a video on youtube stops them than todabia, have the problem look for it like

  • Parvinder June 1, 2009 at 7:30 am

    Great !
    It really works . Thank you !

  • Jhercos June 6, 2009 at 9:49 am

    Hey dude !! You´re efficient and simple, thanks a lot.

    It Worked well for me, Thanks!

  • mysql June 8, 2009 at 9:52 am

    This is a nice clean solution, thanks a lot!

  • Baz June 12, 2009 at 4:25 pm

    You just made my day. Thanks a lot.

  • Mus Adam June 15, 2009 at 10:55 am

    THANK YOUUU. May God bless you =)

  • Vishal June 15, 2009 at 6:13 pm

    Thanks It works !

  • subin June 15, 2009 at 7:16 pm

    Didn’t work for me… tried around 10 times. :(

Newer Comments »

Post comment