Moved to: WoodyHayday.com
Woody Hayday

Fresh Ideas

Hi there! This is my old blog, I don't hang around here much.
You can now find me trying to mix things up here:
Visit WoodyHayday.com Subscribe To My Email List

Cannot Create Windows Service for MySQL. Error:0

If you have MySQL installed (from XAMPP or otherwise) on an xp box (this ones x64) and you update to SP2 it seems to break the mysql service – at least it did for me.  This has happened several times to me but is actually easily resolved. Firstly I tried re-installing mySQL but this brought the problem “Cannot Create Windows Service for MySQL. Error:0” when trying to install the actual service post install.
To get over this you need to wipe the service out so MySQL can recreate it.  Make sure you have admin rights on the box and go to CMD and enter:

sc delete mysql

That should delete the service, then if your in XAMPP just restart the service from your control panel and it will pop up allowing you to add a firewall rule. If you arent using XAMPP simply reinstall mysql after uninstalling/deleting service as above.

This entry was posted in Uncategorized. Bookmark the permalink. Both comments and trackbacks are currently closed.

7 Comments

  1. Haze
    Posted June 21, 2009 at 1:51 pm

    I’ve trawled through pages and pages of Google searches, all the results claiming their method works, yet yours is the only one I’ve found to be successful!

    Thanks.

  2. nanoblast
    Posted June 27, 2009 at 2:12 pm

    hi my problem is, I am trying to install MySQL on my Vista x64…
    the installer I have is MySQL5.1 for 64 bit windows (yes I’m sure)…

    the point is… I never had MySQL on my PC before, but still get the same problem… well at the first install the server couldn’t be started (it created, but I cannot start even at windows task manager, or service manager)

    please Help I need it for an L2j server

    Thanks: Zsolt

  3. Posted July 6, 2009 at 9:54 pm

    You should be fine on vista x64…although its not my preference for an OS unless you have 8gb + ram.

    Does the above not solve it?

  4. Neven
    Posted August 29, 2010 at 3:00 pm

    Thank You very very much. I tried so many “solutions” but just yours helped. 🙂

  5. Posted August 29, 2010 at 8:30 pm

    No worries 😀

  6. Ayeisha
    Posted August 6, 2012 at 1:13 pm

    Great. That was very useful.

  7. Posted August 6, 2012 at 1:29 pm

    🙂 Glad it helped Ayeisha

Woody Hayday

Comments Archive

Hi there. This is my old blog and it's archived, so you can no longer post new comments on this post (Cannot Create Windows Service for MySQL. Error:0).

Read my new blog about writing software and stories at WoodyHayday.com

The New Blog
WoodyHayday.com
A Quote..
"I'm only good at being young"
John Mayer
Old Random Projects
    © Woody Hayday 2008-2019