MySQL install on Mac OS X

I haven’t used my MySQL install on Mac OS X for a while and I’d forgotten where it was located  🙂

By default, it gets installed to /usr/local/mysql-versionnumber, with a symlink /usr/local/mysql pointing to this dir.

Configuring mysqld to listen for remote connections

I’m not sure if I originally configured this or if this is the default. My my.cnf file had this line in it which configures mysql to only listening for incoming connections from localhost and ignores all remote connections:

bind-address            = 127.0.0.1

Changing this to be the real ip of the server will allow it to listen for remote connections.