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”

  • Venu Menon July 29, 2010 at 1:27 am

    Thanks for the steps dude … it worked out fine for me 2 :)

  • santanu_singapore August 16, 2010 at 4:21 pm

    Thanks man, it is working.

  • santhanam October 1, 2010 at 6:38 pm

    Delete the service without uninstalling mysql,
    simply go to the command prompt
    and type
    “sc delete mysql”
    and then
    start the config wizard,

    Santhanam

  • paingiver October 22, 2010 at 6:07 am

    WORKS! THX!

  • cager December 20, 2010 at 9:56 pm

    it didn’t work for me. I’ve tried it a lot of times already. :(

  • trigger December 26, 2010 at 6:11 pm

    didint work for me to and i did this anyway also changed the port it used no luck it just wont start any other idears would help cheers

  • Logan January 6, 2011 at 11:33 am

    It also worked great for me!
    Thank you

  • chanchal January 9, 2011 at 2:03 pm

    thanks buddy..
    bt it didn’t work 4 me …..???
    cn u suggest me another trick through which i able to resolve this problem

  • puneet January 29, 2011 at 3:40 pm

    Thankyou buddy! it works

  • Tommy February 11, 2011 at 11:58 am

    Delete the service without uninstalling mysql,
    simply go to the command prompt
    and type
    “sc delete mysql”
    and then
    start the config wizard,

    Santhanam

    This above works good =] As he said and As the one Andy posted didn’t work for Me, Santhanams did.

  • Shubham February 20, 2011 at 4:15 am

    Worked for me too.
    Thanks

  • Sue February 22, 2011 at 4:36 pm

    its not work..where did you found ‘remove instance’. its not locate in MySQL Server Instance Config Wizard. anyway, thanks

  • bhumi March 5, 2011 at 1:48 am

    worked for me too :-)

  • tbx March 8, 2011 at 1:51 am

    wow, it works man

« Older Comments

Post comment