MySQL 5.5 GA launchd issues with Snow Leopard
Note: This article was originally published at
Planet PHP
on 30 December 2010.
I did a clean install on my Macbook Pro this morning, part of the clean install means, re-downloading things like MySQL.
When I installed it, I noticed that the pref-pane wouldn't start MySQL. Even when it asked for my admin password. I thought maybe it was a boot up issue, so I rebooted, and got an error telling me that the permissions for the start up item were in secure.Here's what I did to debug/fix the problem.
- Change permission of /Library/StartupItems/MySQLCOM/MySQLCOM
- edit /usr/local/mysql/support-files/mysql.server and edited line 46 and 47 to say
Change file ownership
chown -R root:wheel /Library/StartupItems/MySQLCOM
Edit mysql.server file
basedir=/usr/local/mysql
datadir=/usr/local/mysql/data
There is already a bug filed for this..
