/var/lib/mysql/mysql.sock' (111) error.

[66carolin]

I am facing problem with /var/lib/mysql/mysql.sock' (111) error.
How can I fix it?

[77wmaster]

You can run the following command :

service mysql stop
rm -f /var/lib/mysql/mysql.sock
service mysql start
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

[WebMaster]

I agree with you. But if any case it fails then you have to run the following :

The following needed to be in the /etc/my.cnf file:

[mysqld]
set-variable = max_connections=500

[client]
port = 3306
socket = /tmp/mysql.sock
[mysqld]
port = 3306
socket = /tmp/mysql.sock

There are only 2 lines, so you can add the [client] and [mysqld] parts.
You have to run the following commands to shut down the mysql and chkservd.


Service mysql stop :
/etc/rc.d/init.d/chkservd stop

Then you have to removed the following files:
rm -rf /tmp/mysql.sock
rm -rf /var/lib/mysql/mysql.sock

Now restart mysql and chkservd with the following commands and mysql will create the mysql.sock file in the /tmp directory as outlined in the updated my.cnf file:

service mysql start :
/etc/rc.d/init.d/chkservd start

Now create the softlink with this:
ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock

[66carolin]

I want to know that which should be the proper symlink among the two below utilized widely.

A. /tmp/mysql.sock

B. /var/tmp/mysql.sock

[WebMaster]

For the valid link utilized on the server among the above two, check the /etc/my.cnf file for following line.

" socket=/var/tmp/mysql.sock "

You have to build the symlink for the socket remark in above line.