There are many great features available to you once you register at Neowin, including:

  • Richer content, access to many features that are disabled for guests like commenting on the front page
  • Access to a great community, with a massive database of experience on hard & software issues, gaming and recreational activities, and more
  • Access to the Neowin IRC - you could make a friend from across the world and talk to them live
  • Access to Neowin contests & subscription offers and forums that are not open to guests/li>
  • It's simple, and FREE! · Register here
  • 0

Trouble Configuring MySQL 5


 Share

Question

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.

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

  • 0

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.

Link to comment
Share on other sites

  • 0
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?

Link to comment
Share on other sites

  • 0
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.

Link to comment
Share on other sites

This topic is now closed to further replies.
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.