Mysql on Vista

[jonnieos]

this is a repost of my own guide it is still relevant and useful for the community i just don't want to reply on an old thread

Searching how to install MySQL Server I have found answers to typical questions concernig installation in Vista (UAC, side-by-side error fix ( MySQL Bugs: #34340: 5.0.51a: MySQLInstanceConfig.exe will not run on Windows Vista ), firewall, compability), but no complete answer. This is what you do.

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 Resource Hacker
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.

[Clain]

Repost (filla)

[jonnieos]

Repost (filla)

u can't be serious!

[jonnieos]

bump. anyone have feedback

[Avara]

i just installed it : / didnt have any problems what so ever

[Clain]

its only for vista, good guide nonetheless

[jonnieos]

i just installed it : / didnt have any problems what so ever

your cool sorry to disappoint u but this is for people that do have issues

[jonnieos]

ya so any comments about the actual guide!

[arcimagess]

You're the fooking best +2 rep for u!!!

[jonnieos]

You're the fooking best +2 rep for u!!!

no problem man

[Strupantwn]

Lol, don't bump threads that are 2 months old.

I thank when people need this, they will use search

[jonnieos]

people are more aware when the thread is within the recent pages

[ccoa]

But if people had this problem, I'm sure they would search for it.

[mesoalt]

hey i am now getting an error where it says that i dont have acess to mysql on host 'localhost' What should i do? i have vista and had a dif server on this comp b4. im on port 8130 not 8129 because someone told me that it might work. Alright any tips???? Thanks!!

[bboyser8]

This appears to no longer be necessary. I downloaded the most recent version of 5.0 and the Instance Config worked fine on Vista.