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:
- Run regedit
- Delete the key MySQL from HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services
- Reboot (important, otherwise the service does not go away)
- Go to C:\Program Files\MySQL\MySQL Server 5.0\bin
- Right click on MySQLInstanceConfig.exe, and choose “Run as administrator”
- Set it up as you want, and cross your fingers when it comes to starting the service.
Worked for me!
Is this Vista’s fault, or the MySQL development team’s fault?
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.
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?
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.
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?
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.
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….
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
I have problem with mysql server on windoes vista i cant reach my database please if anyone have any solution help me
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
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!
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!
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…