How to install MySQL on Vista machine

I was having some “this application has failed to start because its side-by-side” error while installing the MySQL on my new Vista machine, below is the fix that works for me.

To install MySQL Server 5.0.51a in Vista
1. Disable the UAC in Windows Control Panel->User Accounts
2. Use mysql-essential-5.0.51a-win32.msi
3. In the final step uncheck “Configure MySQL Server now”
4. Download and run Resource Hacker http://www.angusj.com/resourcehacker/
5. Open …\MySQL Server 5.0\bin\MySQLInstanceConfig.exe with Resource Hacker
6. Navigate to 24\1\1033
7. Change
<requestedExecutionLevel level=”asAdministrator” uiAccess=”false”>
to
<requestedExecutionLevel level=”requireAdministrator” uiAccess=”false”>
8. Press “Compile script”
9. Exit Resource Hacker and save the result (overwrite the initial MySQLInstanceConfig.exe)
10. Now MySQLInstanceConfig.exe should start normally.
11. Configure the server.
12. Sometimes the server doesn’t start:
a) Check Windows Firewall settings (3306/TCP)
b) Try changing the compability mode for the file …\MySQL Server 5.0\bin\mysqld-nt.exe to Windows XP-SP2.
13. That’s all.

Tags: ,

This entry was posted on Tuesday, March 25th, 2008 at 5:13 pm and is filed under Web Development. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply