fixing mySQL in Mac OS X 10.4.4 and higher

June 29th, 2006

If you are not a huge nerd, quick! look away:

$ sudo mkdir /var/mysql
$ sudo ln -s /tmp/mysql.sock /var/mysql/

…this is just mostly so I remember. For some nebulous security reason, Apple changed the location of the MySQL socket file in 10.4.4 and higher, and everytime I install MySQL on a new mac server, I forget that. These two commands make a symbolic link from the new location to the old location, so everything MySQL-ish on your Mac can continue to work.

~jeff



« Previously: roth on roth

Next: hex color picker »
  • http://homepage.mac.com/aaronlewis Aaron Lewis

    (Homer Simpson voice )
    Mmmmm….symbolic links….
    (Home Simpson voice )

    Now write a script that checks to see if the socket file has been moved and does the linking for you.

    OR, maybe you should stop and think about how the Gods at Apple might have had a good reason to move it? Maybe you’re using it the WRONG way! I mean, it’s not like they could have made a mistake, right?

  • Ben

    mysqld –socket-path=/var/mysql/mysql.sock

    -or-

    /etc/my.cnf:
    [mysqld]
    socket=/var/mysql/mysql.sock

    -or, better yet-

    /etc/my.cnf:
    [client]
    socket=/tmp/mysql.sock

    -or, better still-
    /etc/my.cnf:
    [mysqld]
    socket=/Users/jeff/Desktop/mysql.sock

    [client]
    socket=/Users/jeff/Desktop/mysql.sock