Trouble Configuring MySQL 5

[mshepp]

I am trying to get MySQL 5 working, has to be this version. It installs but at the end where you click finish and then configure the server it just finishes without asking to configure server. When i then try and run MySQL command line it opens and closes instantly. The MySQL server instance config wizard doesnt work either, it comes up and says

"This file does not have a program associated with it for performing this action. Create an association in the Set Associations control panel"

Has anyone else experienced this problem and knows how to correct it.

I am using Vista 64bit and have downloaded the 64 bit version of mysql.

[mshepp]

I just found the fix for anyone else who ever has the same problem.

Searching how to install MySQL Server I have found answers to typical questions concernig installation in Vista (UAC, side-by-side error fix ( http://bugs.mysql.com/bug.php?id=34340 ), firewall, compability), but no complete answer. After spending several hours finally I got my server running. So here is the algorithm.

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.

[archetwist]

mshepp, you are my hero :) . The fix works as intended.

[jjschade]

I just found the fix for anyone else who ever has the same problem.

I just found the fix for anyone else who ever has the same problem.

What do you mean by the 2nd step, "Use mysql-essential-5.0.51a-win32.msi ?"

Is this a file that should be on my computer after the download? I did a search and it did not turn up. I opened every folder in the mySQL folder and there are no .msi files there.

Do you mean to first find the file, then set an association of it with the instanceconfig .exe file?

[Wilhelmus]

What do you mean by the 2nd step, "Use mysql-essential-5.0.51a-win32.msi ?"

Is this a file that should be on my computer after the download? I did a search and it did not turn up. I opened every folder in the mySQL folder and there are no .msi files there.

Do you mean to first find the file, then set an association of it with the instanceconfig .exe file?

Most likely this means that you need to download & install Windows Essentials package.

Then do the other steps.

[SimplePerson]

I just found the fix for anyone else who ever has the same problem.

Thats really very Good, Hats off to you.

Regards,

SimplePerson