On Apr 2, 2008, at 6:01 AM, sourceforge.rocks@xemaps.com wrote:

A step you may want to add is creating a symlink from /tmp/ mysql.sock to /opt/local/var/run/mysql5/mysqld.sock:

sudo ln -s /opt/local/var/run/mysql5/mysqld.sock /tmp/mysql.sock

This is for people who want to use the MySQL Administrator and/or MySQL Query Browser supplied by MySQL

I have not used either, but I would imagine that MySQL Administrator and/or MySQL Query Browser probably have a connection profile that allows you to specify the correct socket in a similar fashion to the Navicat steps I listed below : Somewhere I was reading yesterday that there was vulnerability associated with '/tmp/mysql.sock', so setting the preferences in MySQL Administrator with the correct path might be a better solution than the soft link to a file that gets created and destroyed every time the MySQL-Server starts and stops. This is a little piece from a previous comment I posted: To avoid : Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) You will need to make sure MySQL-Server is running by using : $ ps aux | grep mysql You should also make sure that the two configuration files "my.cnf", and "php.ini" have the same path to where the socket file will be created when MySQL-Server starts up.. MACPORTS LOCATIONS : ( a ) /opt/local/etc/mysql5/my.cnf should contain something like : [mysqld] port = 3306 socket = /opt/local/var/run/mysql5/mysqld.sock ( b ) /opt/local/etc/php.ini should contain something like : [MySQL] mysql.default_socket = /opt/local/var/run/mysql5/mysqld.sock ( c ) if using a GUI like Navicat the preferences have to specify the correct path for the socket If using Navicat try the following : ( 1 ) Select a connection profile from the "Connections" portion (left side) of the Navicat window ( 2 ) Select "Connection --> Connetion Properties..." from the menubar ( 3 ) Select the "Advanced" tab ( 4 ) Check the "Use socket for localhost Connection" checkbox ( 5 ) Set the "Socket File Path :" field to "/opt/local/var/ run/mysql5/mysqld.sock" without the quotes ( 6 ) Click the "Test Connection" button, and if MySQL is running you should see "Connetion Successful" These are handy : ( 1 ) open -a /Applications/BBEdit.app /opt/local/etc/mysql5/my.cnf ( 2 ) open -a /Applications/BBEdit.app /opt/local/etc/php.ini ( 3 ) open /Applications/Navicat.app Best Regards, Bill Hernandez ms@mac-specialist.com