bingshui.org

the Life of Zim

12th January
2010
written by dzimney

Today I finally upgraded to Snow Leopard from just plain ol’ Leopard. By doing this I found that my localhost configurations had gotten a little jacked up in the process. The first issue was that my /etc/apache2/extra/httpd-vhosts.conf file had been overwritten. Pain in the ass, but not too big of a deal to fix. The next issue though was that my MySQL database would not start.

Ashitaka: sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
Password:
Could not find MySQL startup script!

With the help of this post on www.planet-geek.com I was able to get things up and running in no time.

The fix:
It appears the issue here is that Snow Leopard updates the path name to MySQL. I’m assuming to keep a 32-bit version from attempting to launch on the new 64-bit OS. To fix this, you’ll simply need to create a symbolic link to the new directory.

Ashitaka: cd /usr/local
Ashitaka: ls -ldt mysql*
drwxr-xr-x 17 root wheel 578 Sep 1 00:31 mysql-5.1.30-osx10.5-x86_64
Ashitaka: sudo ln -s mysql-5.1.37-osx10.5-x86_64/ mysql
Ashitaka: ls -ldt mysql*
lrwxr-xr-x 1 root wheel 28 Jan 12 17:07 mysql -> mysql-5.1.30-osx10.5-x86_64/
drwxr-xr-x 17 root wheel 578 Jan 12 13:05 mysql-5.1.30-osx10.5-x86_64

Keep in mind that you’ll need to double check the folder names. Mine was mysql-5.1.30-osx10.5-x86_64 while the author of the Planet Geek article had mysql-5.1.37-osx10.5-x86_64. This reflects the version of MySQL installed, so it’s quite possible this will vary.

Leave a Reply