Creative Juices Bo. Co.

Satisfy Your Thirst For Something Refreshing!

Installing MySQL 5.5.8 on Mac OS X Headache

MySQL We Have A Problem

Argh... So I wanted to update my internal server to the latest and greatest version of MySQL. I downloaded the nice Mac OS X ver. 10.6 (x86, 64-bit), DMG Archive installer package they have and low and behold, MySQL won't start-up!

Well, no need to worry. Seems to be an issue with the installer package. To see if you have the same problem I'm having, do the install and then fire up ye ole terminals and type:

sudo /usr/local/mysql/support-files/mysql.server start
Password: XXXXXX

If you see a fun message that looks like this:

/usr/local/mysql/support-files/mysql.server: line 256: my_print_defaults: command not found
Starting MySQL
ERROR! Couldn't find MySQL server (./bin/mysqld_safe)

Then you have the same problem I'm having. Here's how you can fix it.

You need to edit the mysql.server file located in /usr/local/mysql/support-files/. You can do this in terminal using emac if you like, but I just find it easier to use BBEdit. Either way you need to search for the lines that looks like this:

basedir=
datadir=

... and change them to this:

basedir=/usr/local/mysql
datadir=/usr/local/mysql/data

Reboot your computer and MySQL should be running for you. Why is it every time MySQL does an update, they seem to break something? The solution was graciously posted here: http://forums.mysql.com/read.php?11,399397,399606#msg-399606