Cowboy Programming Game Development and General Hacking by the Old West

October 29, 2007

MySQL Server Install Problems with Vista

Filed under: Random — Mick West @ 3:07 pm

Oh Vista, how do I dislike thee!

Grr – trying to install MySQl server 5.0 on Windows Vista was rather frustrating, as it simply stopped with “Unable to start service, error 1067”. Especially annoying as I flawlessly installed the thing on my XP laptop in two minutes last night.

You would think someone would have fixed this now, but no, the googlesphere advice seemed to be to re-run the install program as administrator. This failed to work. But I gathered from faint intimations that you had to remove the service for it to be properly re-installed. So, the steps that seemed to work for me were:

  1. Run regedit
  2. Delete the key MySQL from HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
  3. Reboot (important, otherwise the service does not go away)
  4. Go to C:\Program Files\MySQL\MySQL Server 5.0\bin
  5. Right click on MySQLInstanceConfig.exe, and choose “Run as administrator”
  6. Set it up as you want, and cross your fingers when it comes to starting the service.

Worked for me!

21 Comments »

  1. Is this Vista’s fault, or the MySQL development team’s fault?

    Comment by capn_midnight — December 26, 2007 @ 2:56 am

  2. A bit of both I reckon. But also neither. It’s a new operating system. Some things are going to break. It’s just a question of how quickly they get fixed.

    Basically though, MySQL should have been aware of the issue buy this point, and it should have been addressed one way or another.

    Comment by Mick West — December 26, 2007 @ 9:29 pm

  3. Ever notice that MySQL on Vista is extremely slow when connecting from other boxes on your network? Simple PHP pages take 5 or more seconds to connect. Unacceptable. I tried disabling UAC, DEP, and giving priority to background processes. No luck. I’ve seen many reports online of the same thing, but with no resolution:
    http://forums.mysql.com/read.php?52,186102,186102

    Any ideas?

    Comment by Russ Brooks — January 26, 2008 @ 8:56 am

  4. I’m afraid not. I’ve only tested MySQL on Vista running of the same machine. For multi-machine connections I’d used a remote Linux server.

    Comment by Mick West — January 26, 2008 @ 9:28 am

  5. Mysql is not working on vista. I dont find key MySQL in HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services which i have to delete.
    What i will do?

    Comment by Malik — April 1, 2008 @ 3:04 am

  6. Sorry Malik, I’m no expert here – I just found a solution that worked for my problem. It sounds like you have a different problem. I’d suggest you gather more details as to exactly what you do, and what the symptoms are, and then post it to a MySQL group.

    Comment by Mick West — April 1, 2008 @ 7:32 am

  7. hi i tried the same thng but it didin’t worked….i’m getting the same error msg again…

    “application has failed to start coz its side_by_side configuration is incorrect….”

    plz suggest me ny other way to deal with this problem….

    Comment by rachit — May 23, 2008 @ 7:30 am

  8. You might need to reinstall the Visual C++ redistributables. Maybe:

    http://www.microsoft.com/downloads/details.aspx?familyid=9B2DA534-3E03-4391-8A4D-074B9F2BC1BF&displaylang=en

    Comment by Mick West — May 23, 2008 @ 7:42 am

  9. I have problem with mysql server on windoes vista i cant reach my database please if anyone have any solution help me

    Comment by kwaa — January 3, 2009 @ 2:42 pm

  10. If the installer is an .msi you have to do a .bat script trick. I describer how you do it here:
    http://www.defblog.se/permalink/1998.html

    Comment by defdac — February 26, 2009 @ 7:14 am

  11. Thanks for this info. Been searching for answer to this for awhile and I stumbled onto this page just when I was about to give up.

    Keep up the good work!

    Comment by Matt — April 5, 2009 @ 12:08 am

  12. hey man, that was it!!

    I tried so many other sollutions! but I never thought of running the instance config as admin!
    lol…. thank you very much!

    Comment by GMX — May 6, 2009 @ 8:09 am

  13. MySQL was running for a while and then suddenly it doesn’t work anymore. Good stuff!!!

    I have now several databases and application that are worthless since I can’t connect to MySQL anymore.

    I tried installing MySQL 5.1 (several times) still nothing.

    Of course this is Vista’s fault!!! They probably did it in one of their dayly updates…

    Comment by Manu — June 1, 2009 @ 2:14 am

  14. I will give this a shot.

    Comment by Bill — July 4, 2009 @ 1:21 am

  15. I have wrestled with getting MySQL to work with Dreamweaver and PHP for quite some time (off and on over a period of months) with no success. THIS WORKED! Thanks!

    Comment by Hugh — July 9, 2009 @ 6:03 am

  16. You are a genious …. i was fighting with this for about an hour and after looking at your post …. i felt it would not work as i thought this is what will kill me … but finally your suggestion worked … although the security settings could not be applied … anyways thanks a ton …..

    Comment by Krishna — August 7, 2009 @ 6:37 am

  17. I tried everything, including the bat script trick by def. still can’t run the instanceConfig. Tried running it as admin, no success.. please help

    Comment by Phillip — September 9, 2009 @ 6:47 pm

  18. Sorry, I’ve not done anything with it beyond the above.

    Comment by Mick West — September 9, 2009 @ 8:06 pm

  19. I have the same problem as phillip….nothing is working!I had it installed fine before, when i tried to run the server the first time, it froze and wouldnt do anything. so i uninstalled, did the reigstry service things etc reinstalled then it started giving me the “cant start servive” error. so i followed all the steps given above, and it still isn’t working. :(

    Comment by Cindy — September 20, 2009 @ 5:39 am

  20. I removed MySQL 5.0 from my Windows Server 2008 box and tried installing MySQL 5.1 and ran into this same error. I tried dozens of recommended things to get it to work again, finally what worked was:
    1. Completely remove all traces of MySQL (uninstall, remove service, delete folders).
    2. Reboot.
    3. Reinstall MySQL as Administrator, do not choose to configure service right away.
    4. Run Instance Config tool as Administrator (Which still gave me the error can’t start service).
    5. Copy my old my.ini file over the new one.
    6. “Net Start MySQL” as administrator.
    7. Viola! It worked for me, finally.

    I can’t say why the config file it writes will not start, but this seemed to work finally after 2 days of trying. Hope it helps someone.

    Comment by Justin — October 12, 2009 @ 7:14 am

  21. I have been trying to install mySQL 5.1 since several days, the service does not start, throws error 1067. Tried all combinations – it is not working out on VISTA Home premium, but it has in XP. Could any one suggest a definite procedure pl?

    Comment by Patil S K — October 19, 2009 @ 8:39 pm

RSS feed for comments on this post. TrackBack URL

Leave a comment

You must be logged in to post a comment.

Powered by WordPress