The installation of MySQL Server 5.0 on Windows Vista is not straightforward as it requires a bit of tweaking to successfully start running the server. I don’t know why still there is no fix for this problem from the MySQL team at Sun Microsystems. I hope they will patch up this issue in their upcoming release (5.1). I have spent a fairly good amount of time to find a work around for this problem & have been successful with my stab after quite a bit of research on the net.
Following are the 8 steps that I followed to Install MySQL 5.0 on my Vista Machine
1) Turn off the User Account Control (UAC) feature from Control Panel -> User Accounts.
2) Download & Install the MySQL SetUp.EXE & in the final step when the configuration wizard pop’s up, uncheck the ‘configure’ check box & click on finish.
3) Download the Resource Hacker software from here. Resource Hacker is a free software to view & modify the 32 bit windows executables & resource files.
4) Open the ‘MySQL Server 5.0binMySQLInstanceConfig.exe’ using Resource Hacker.
5) Traverse to 2411033 & add the following statement inside the <dependentAssembly> XML element.
<requestedExecutionLevel level=”requireAdministrator” uiAccess=”false”>
If there is already a ‘requestedExecutionLevel‘ element with level=”asAdministrator”, just replace the “asAdministrator” with “requireAdministrator“.
6) Click on Compile Script & close the Resource Hacker.
7) Now, go to Control Panel ->Windows Firewall -> Allow a Program through a Windows Firewall & add a TCP port 3306.
8) Now start the ‘MySQL Server Instance Config Wizard’ & configure the server.
By this time the server should be up & running without any errors.
