Re: connection error - Can't connect to local MySQL server through socket '/tmp/mysql-xxxxx.sock' (111)

[Julian Davtchev]

Not sure if this would help but hope so :)
You could set in your my.cnf file where exactly should mysqld create the socket file. Here is an example of the my-xxx.cnf file provided with mysql.
--------------------------------------------------------------
# You can copy this file to
# /etc/my.cnf to set global options,
# mysql-data-dir/my.cnf to set server-specific options (in this
# installation this directory is /usr/local/mysql/data) or
# ~/.my.cnf to set user-specific options.
......
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3306
socket = /tmp/mysql.sock

# Here follows entries for some specific programs

# The MySQL server
[mysqld]
port = 3306
socket = /tmp/mysql.sock
......
--------------------------------------------------------------