Mar
11
129

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.

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

  • MH August 26, 2009 at 2:23 pm

    Thanks a lot, worked like a charm and saved me hours of frustration! =)

  • darion nguyen August 26, 2009 at 10:45 pm

    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.

  • Emma A. August 28, 2009 at 4:21 am

    Thanks!! It worked for me!

  • Saik August 28, 2009 at 3:11 pm

    Thank You :)

  • lyufer August 29, 2009 at 10:55 pm

    thanks.. men… work this methods

  • Colin August 30, 2009 at 3:03 am

    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

  • Vincent Duvernet August 30, 2009 at 5:50 pm

    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)

  • Shirish August 31, 2009 at 4:52 pm

    Its Works..!.. thanks
    but the error with the “Apply security Settings” >> I used W2k3 server with SP2 and MySQL 6

    Thanks

  • Shirish August 31, 2009 at 5:06 pm

    It also works…
    Thanks

  • Lester September 2, 2009 at 12:38 pm

    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.

  • Shankar Kumar September 2, 2009 at 10:05 pm

    Thanks for this.

  • Kaushik Saha September 3, 2009 at 6:38 pm

    Problem not solved…Same problem occurring.

  • saadatch September 8, 2009 at 2:52 pm

    Thanks a lot, it solves my problem.

    Regards,

    Saadat R.Chaudhry

  • Nathi September 9, 2009 at 5:36 am

    Thank you this worked perfectly…

  • Nikhil September 14, 2009 at 4:16 am

    Thank Lot Buddy this work you are genius :) .

  • inpuffiva September 17, 2009 at 3:04 pm

    instructively put down , hasten to continuing.

  • Tdrox September 17, 2009 at 5:33 pm

    Thanks, easy and strong solution.

    GOD bless

  • Alan September 22, 2009 at 3:02 pm

    Thanks a lot ~~ The problem have drove me crazy until I found this post.

  • Pradeep September 26, 2009 at 11:41 pm

    It worked for me.Thats really great!!!

  • simko September 27, 2009 at 5:17 pm

    Thanks a lot :)

  • Marc October 30, 2009 at 4:11 am

    It worked for me.
    1000 kisses.

  • marjon November 7, 2009 at 8:44 pm

    it works!!!!! thanks a lot muah…..

  • Shie November 16, 2009 at 7:19 am

    Once I get to the point where all it has to do is “Start service” in the installation, the program stops responding.

  • Atta Sumalani November 28, 2009 at 1:00 am

    the easiest way is to delete the service without uninstalling mysql, simply go to the command prompt and type “sc delete mysql” and then start the config wizard, it will workout just fine.

    MAKE YOUR LIFE EASY MAN….

  • Simon December 7, 2009 at 9:50 pm

    Didn’t work for me the first couple of times.

    Then it finally worked but only after I used Detailed Configuration (not Standard).

  • Totally Frustrated MySQL Newbie December 8, 2009 at 12:19 am

    This MySQL installation is a pile of garbage.
    I can’t believe how many people have had this error and still there is not one of the solutions posted that actually work for me. Don’t these developers take their target user-base seriously? If this was commercial software the company would be out of business and we’d all have another solution from competent developers that actually worked.

  • Martin December 27, 2009 at 11:52 pm

    PROBLEM SOLVED: i have IIS7, PHP 5.3 and MYSQL 5.5. installed on my windows 2008 server.

    1. UNINSTAL YOUR PHP AND DELETE DIR.
    2. STOP THE MYSQL SERVICE- remove instance, AND UNINSTALL – windows uninstall
    3. DELETE EVERY mysql dll file ON YOUR HARD DRIVE
    4. START UP REGEDIT AND SEARCH FOR MYSQL, DELETE EVERY KEY THAT POINTS TO MYSQL.
    5. REBOOT COMPUTER
    The most important steps:
    6. FIRST INSTALL MYSQL, USE STANDARD CONFIGURATION !!!!
    7. THEN INSTAL PHP AFTER MYSQL

    IT SEEMS THAT PHP BLOCKS MYSQL SERVICE WITH ITS OWN ONES.

    Hope it helps.

  • Superrookie December 29, 2009 at 10:28 am

    I had problem the same problem after installing Visualstudio8 and downgrading PHP5.3 to PHP5.29

    Had tried above suggestion but didn’t work,

    Anyway, finally, I got a solution.

    1. Uninstall PHP5 (

    2. Run “MySQL Server Instance… configuration ”

    3. Remove instance

    4. Run “MySQL server… Configuration” again

    5. Choose “Detail confi…”

    6. Next , Next

    7. At “InnoDB telespace… setting” ., choose “Modify” and brows a folder containing your DB part.

    8. Click next until finish.

« Older Comments

Post comment