mySql server won't start after upgradge to mac osx 10.6 Snow Leopard

After upgrading to Snow Leopard the mySQL server would not start. I found the solution here:

http://www.macintouch.com/readerreports/snowleopard/topic4883.html. You have to search down the page to find the solution, search for Ralph Martin or mySql.

The upgrade to Snow Leopard seems to have broke the symbolic link.

Ralph Martin

I too found that MySQL wouldn't start after upgrading to Snow Leopard.

The answer seems straightforward. Previously there was a symbolic link from
/usr/local/mysql
to
/usr/local/mysql-5.1.37-osx10.5-x86_64
and this seems to have been deleted by the upgrade process.

I got MySQL working again by doing

cd /usr/local
sudo ln -s mysql-5.1.37-osx10.5-x86_64 mysql

(note that you may have to modify this slightly if your MySQL is a different version).

Installing mySql on Mac OSX Leopard

Just got done installing mysql on my macbook pro. Installation went just fine. Followed the same document that also had php installation instructions. Click here to view that document again.

I accepted all the defaults and have not yet gone through the instructions for connecting to php. A couple of places I stumbled only briefly. As mentioned in the article I downloaded the MySQL GUI Tools. This gives a visual interface and will definately work better for me as I still have no clue to all the command line stuff on this mac. After installing the gui and clicking on the MySql Administrator app in the applications folder I was given the option for a server and username and password. Server Hostname can be set to "localhost" and username to "root". Then you can change the password when you get in there.

Very simple. Now I gotta learn the interface.