OSX Snow Leopard MySQL startup problem – Fixed!

I do a lot of work on MySQL as part of the CONGO project (oh, and incidentally, as part of my full time job), so I was somewhat stymied when, after my upgrade to Snow Leopard (aka OSX 10.6.0), I was unable to start my local MySQL server – I’d get this:

yacht:~ dbs$ sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
Password:
Could not find MySQL startup script!

It turns out that as part of the MySQL upgrade, the path to the MySQL installation changed (or a symlink was removed, or something to that effect) – at any rate, /usr/local/mysql no longer existed.
Easy enough to fix, just put a symlink in:

yacht:~ dbs$ cd /usr/local
yacht:local dbs$ ls -ldt mysql*
drwxr-xr-x  17 root  wheel  578 Sep  1 00:31 mysql-5.1.37-osx10.5-x86_64
yacht:local dbs$ sudo ln -s mysql-5.1.37-osx10.5-x86_64/ mysql
yacht:local dbs$ ls -ldt mysql*
lrwxr-xr-x   1 root  wheel   28 Sep  2 12:52 mysql -> mysql-5.1.37-osx10.5-x86_64/
drwxr-xr-x  17 root  wheel  578 Sep  1 00:31 mysql-5.1.37-osx10.5-x86_64

After making the symlink, the startup script ran just fine:

yacht:local dbs$ cd /Library/StartupItems/MySQLCOM/
yacht:MySQLCOM dbs$ sudo ./MySQLCOM start
Starting MySQL database server
yacht:MySQLCOM dbs$ _

I share this to ya’ll for the betterment of geek-kind. 🙂

About

A wandering geek. Toys, shiny things, pursuits and distractions.

View all posts by

4 thoughts on “OSX Snow Leopard MySQL startup problem – Fixed!

  1. Thank you for this. I don’t need to go into MySQL very often on my local machine and tonight was the first time I had to get in since I upgraded to Snow Leopard.

  2. Thanks much for posting this! Fixes the problem nicely.
    One formatting suggestion:
    In my browser window, the final “l” is cut off on the line where you create the symlink, making it look like you’re saying to create a symlink called “mysq”. It was pretty clear what you meant, but it was still mildly confusing for a moment.
    So for clarity, it might be worth styling your pre tag with overflow:auto, which should add a horizontal scroll bar in browser windows where one is needed.
    …Btw, on an unrelated note, I tried signing in here using TypeKey, but it gave me some kind of error about a site not being registered. Do you have a TypeKey registration number set up in your MT settings?
    Anyway, thanks again!

  3. Jed, thanks very much for the feedback..
    I do indeed have a TypeKey token, and it’s configured into the blog, but it’s possible my typekey mapping was wrong. Could you try it again and let me know if it works?

Leave a Reply

Your email address will not be published. Required fields are marked *