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 ( [Only registered and activated users can see links. ] ), 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 [Only registered and activated users can see links. ]
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.
2 years have passed since the mortal races banded together to emulate World of Warcraft...
But the alliances have been broken and the drums of flaming thunders sounded once again. Developer of Spurious.
2 years have passed since the mortal races banded together to emulate World of Warcraft...
But the alliances have been broken and the drums of flaming thunders sounded once again. Developer of Spurious.
I thank when people need this, they will use search
[Only registered and activated users can see links. ][Only registered and activated users can see links. ] [Only registered and activated users can see links. ] [Only registered and activated users can see links. ]
Site n00b.. (A leecher if I've been here for more than a month and can't earn 5 rep)
Rep Power: 2
Reputation: 2
Posts: 6
Join Date: Jun 2007
07-01-2008
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!!