MySQL Dead

[ramorse]

MySQL server appears down. Trying to restart it in WHM I get the following 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' (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 "mysql has failed").

Any ideas?

[cpanelnick]

MySQL server appears down. Trying to restart it in WHM I get the following 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' (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 "mysql has failed").

Any ideas?

Please open a ticket @ https://tickets.cpanel.net/submit/

[ramorse]

I have submitted a support ticket. Thanks.

[Ghulam Yaseen]

Hello ,

The possible issues with your mysql may be:

--> permission issue at /var/lib/mysql/
/usr/lib/mysql

--> link is not present at /tmp

--> mysql processes are messed

can you kindly come ahead with more info on this

MySQL server appears down. Trying to restart it in WHM I get the following 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' (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 "mysql has failed").

Any ideas?

[apscinsspl]

To start mysql if everthing fails


killall -9 mysqld
cd /etc/rc.d/init.d
safe_mysqld --skip-grant-tables &
CTRL+C
mysqladmin status