Getting MySQL Preference Pane To Work In Leopard
The most visited post on my blog is the post regarding a fix for getting MySQL to run on Leopard. Today, Charlie Jackson posted a comment to that post with a fix he discovered for getting the preference pane to work so you no longer have to start/stop MySQL via the commandline. So that it wouldnt be buried in the comments, I decided to post it here.
First, open a terminal window and enter the following commands:
mv mysql.server mysql.server.real
Next, you will need to edit the new mysql.server file that we just created with the touch command. I used textmate by simply typing “mate mysql.server”, but you could use vi or whatever you want.
Once you have the file open for editing, simply enter the following code into the file and save it.
sudo /usr/local/mysql/support-files/mysql.server.real $1
Once this was done, I had to change the permissions on the file to get it to work so I ran the following in the terminal:
sudo chown root:wheel mysql.server
sudo chmod +x mysql.server
After that, fire up your system preferences and test the MySQL pane. Mine starts and stops the server perfectly.
Thanks again Charlie!
—– UPDATE! ——
Lars posted in the comments below a link to a patched pref pane that has been FINALLY released! Thanks for pointing this out Lars!
I have installed it on both my 24″ iMac and my MBP and it works great!
Grab it here