mysql51-server socket

[Bradley Giesbrecht]

On Jun 21, 2012, at 7:15 AM, Craig Treleaven wrote:

> Hi:
> 
> I was testing a fresh install of mysql51-server (on 10.7.4) and I'm having a problem that the socket is not where it is supposed to be:
> 
>> $ mysql5 < /opt/local/share/mythtv/database/mc.sql
>> ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/opt/local/var/run/mysql5/mysqld.sock' (2)
>> 
>> $ mysql_config5 --socket
>> /opt/local/var/run/mysql5/mysqld.sock
>> 
>> $ ls -al /opt/local/var/run/mysql5/mysqld.sock
>> ls: /opt/local/var/run/mysql5/mysqld.sock: No such file or directory
>> 
>> $ ls -al /opt/local/var/run/mysql51
>> total 0
>> drwxr-xr-x  4 _mysql  _mysql  136 21 Jun 08:50 .
>> drwxr-xr-x  5 root    admin   170 21 Jun 09:06 ..
>> -rw-r--r--  1 root    _mysql    0  3 May 14:22 .turd_mysql51-server
>> srwxrwxrwx  1 _mysql  _mysql    0 21 Jun 08:50 mysqld.sock
> 
> I tried to use /opt/local/etc/mysql51/my.cnf to indicate the socket:
>> # Use default MacPorts settings
>> !include /opt/local/etc/mysql51/macports-default.cnf
>> 
>> # WCT modifications 2012Jun21 -
>> port		= 3306
>> socket		= /opt/local/var/run/mysql51/mysqld.sock
> 
> No success.  Should I file a ticket?  Is there a workaround in the meantime?

The mysql5 port has not yet been replaced_by mysql55. The mysql51 port was created for those that are not ready to upgrade to mysql55 when mysql5 is eventually replaced_by mysql55.


If you want to use mysql51 then you will want to use the mysql51 executables:
$ port contents mysql51 | grep /bin/


There is also the mysql_select port which will put simlink executables into your path:
$ sudo port select mysql mysql51
$ which mysql
/opt/local/bin/mysql
$ ls -la $(which mysql)
lrwxr-xr-x  1 root  admin  32 Jun 21 07:32 /opt/local/bin/mysql -> /opt/local/lib/mysql51/bin/mysql



Regards,
Bradley Giesbrecht (pixilla)

-------------- next part --------------
A non-text attachment was scrubbed...
Name: smime.p7s
Type: application/pkcs7-signature
Size: 2763 bytes
Desc: not available
URL: <http://lists.macosforge.org/pipermail/macports-dev/attachments/20120621/8dc2f0e8/attachment.bin>