Saturday 5 July 2008

On Vista, MySQL System Tray Monitor cannot start mysql server

This problem caused me a bit of pain. I installed mysql and the gui tools, and all was well on Vista. However, when I rebooted (and I turned off the automatic starting of the mysql service), once up, I couldn't start up the mysql server. This may have been caused by installing as one user, and then using mysql through another user.

The answer:
  • Run MySQL System Tray Monitor as Administrator
How to do this automatically?
  • Click the Windows Start button (the big one at the bottom left with the logo)
  • Click on All Programs
  • Scroll until you find Startup
  • Click on Startup
  • Inside, right click on MySQL System Tray Monitor
  • Select Properties
  • Click on the Compatibility tab
  • At the bottom, in the Privilege Level box, click Run this program as administrator
  • Click the OK button
Additionally, if you want
  • If the MySQL System Tray Monitor is already started, stop it and run it again from here.
  • You can also set the same setting for MySQL Administrator
  • The same programs are also in the MySQL group in All Programs if you are not starting the System Tray Monitor automatically, you'll have to make the changes here.
Hope this helps someone. Any questions, please comment.

No comments: