Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

[neomas]

I don't know how to solve error

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)

when i restart SQL Server (MySQL) on WHM
it's error

/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (111)'
Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!
mysql has failed, please contact the sysadmin (result was "mysql has failed").

[Stephanie_R]

Sounds like something ate your symlink in /tmp

ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock

restart MySQL

[neomas]

I try to solved and fixed everything but still same.
I don't know how to solve about this problem.

pls. help me.

[rpmws]

Originally Posted by neomas

I try to solved and fixed everything but still same.
I don't know how to solve about this problem.

pls. help me.

/scripts/restartsrv_mysql

if that doesn't work.

/scripts/mysqlup --force

[cpanelkenneth]

Also try

/scripts/mysqlconnectioncheck

[romyloice]

Same with me..

Mine :
WHM 11.15.0 cPanel 11.18.5-R24173
CENTOS Enterprise 5 x86_64 on standard - WHM X v3.1.0

/scripts/mysqlup --force
completed, but still have the same problem..
error message :
/usr/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)' Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists! mysql has failed, please contact the sysadmin (result was "Warning, no valid mysql.sock file found.mysql has failed").

checking /var/lib/mysql/mysql.sock does not exist..

/scripts/mysqlconnectioncheck gives nothing..

Any clue ??

[shital]

Hello,

Did you check the partition size on file system?? I mean may be /var is 100% full on server. Thats the reason mysql could not be started on server.

MySQL sock file not found
====================

= killall -9 mysqld
= service mysql stop
=cp var/lib/mysql/mysql.sock var/lib/mysql/mysql.sock_backup
= rm -f /var/lib/mysql/mysql.sock
= service mysql start
= ln -s /tmp/mysql.sock /var/lib/mysql/mysql.sock
= /scripts/restartsrv mysql

Hope this will help you to resolve this issue as it helps me always

Shital

[Bigwebmaster]

Try and open up your /etc/my.cnf file and see if you can find this:

[mysql.server]
user=mysql
basedir=/var/lib

Comment out the basedir variable so that it looks like this:

[mysql.server]
user=mysql
#basedir=/var/lib

Then try and restart mysql and see if that fixes it.

[FourMat]

Originally Posted by Bigwebmaster

Comment out the basedir variable so that it looks like this:

[mysql.server]
user=mysql
#basedir=/var/lib

Then try and restart mysql and see if that fixes it.

Can someone tell me why this works?

I just made that change and now my mysql server is up and running after having the same problem as the original poster.....

[cpanelkenneth]

Originally Posted by FourMat

Can someone tell me why this works?

I just made that change and now my mysql server is up and running after having the same problem as the original poster.....

The basedir directive instructs MySQL where to find everything it needs to function: binaries, libraries, data, etc. Hence by stipulating basedir=/var/lib, MySQL will search /var/lib for everything needed to perform its functions.

For typical installs via RPM, this directive is not needed and should not be used. For a more exhaustive description of this directive, please consult the MySQL manual.

[FourMat]

Thanks for the info. I am trying to get this newly configured server up and running and was a little surprised to find that the mysql server wasn't working out of the box.

Thanks for the help!

[cpanelkenneth]

Originally Posted by FourMat

Thanks for the info. I am trying to get this newly configured server up and running and was a little surprised to find that the mysql server wasn't working out of the box.

Thanks for the help!

Nothing in cPanel adds the basedir directive to /etc/my.cnf, which means it was added by something/someone outside cPanel's functions.

[bhstudios]

Originally Posted by FourMat

Can someone tell me why this works?

I just made that change and now my mysql server is up and running after having the same problem as the original poster.....

Excellent contribution, i was totally lost tried evrything, only think that worked was this, thanks FourMat