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:
... and change them to this:
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