[Guide] How to make MySQL work on Vista

[makka]

when trying to install mysql on my vista PC i hit a prob right at the end of the installation when you are ment to confer the server it wont run because the file is corrupt easy fix i found :-

1. Disable the UAC in Windows Control Panel->User Accounts (Restart req)

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

To view the content, you need to sign in or register

To view the content, you need to sign in or register

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.

hope this helps you as much as it helped me

 

[Astrup]

Good guide, but i suggest to just not run a server on Windows Vista for public.
Private should be no problem, but wont even try to make it public on Windows Vista!

 

[jos15]

me when i instal it i don't got any prob my server is now public with no prob

 

[Juggalo90]

Yea...Vista is a memory hog as it is...

 

[jos15]

1 got 4g ram

 

[Juggalo90]

Still...Vista is still buggy...
Imo Windows 2003 or 2000 server

 

[makka]

yeah i had the upgrade just sitting there in a box so i used it =P

pain in the ass getting this working thou ^^

 

[Juggalo90]

Lol ya
SP1 is actually really nice