MACPORTS - mysql5 install on Leopard - step by step instructions

[Bill Hernandez]

On Apr 2, 2008, at 6:01 AM, sourceforge.rocks at 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 at mac-specialist.com