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.
7 Comments
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.
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
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?
Thank You very very much. I tried so many “solutions” but just yours helped. 🙂
No worries 😀
Great. That was very useful.
🙂 Glad it helped Ayeisha
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