MacPorts mysql with GUI tools

A friend had some problems installing MySql with MacPorts and asked me if I had problems installing it.  Our problems were totally unrelated but thinking back, I remembered I had problem with MySQL Query Browser.  I couldn’t get it to connect even though I could connect via the command line.  It turned out to just have the wrong path for the socket file.

Click the triangle next to the “More Options” label on the connection string an change the “Connect Using Socket” field to the path of your socket file.

To determine where your socket file is, type:

netstat -ln | grep mysql