mysql is dead but subsys locked

Question

I am using PHP-mysql on Linux (RHEL 5.0) For First Time
When I tried to connect to MySQL from my PHP Script using mysqli_connect.
It Displayed The Following Error:

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

After googling for hour I found solution to this as stated here.

When I followed that approach and issued command:

service mysqld status

as a root user I got : mysql is dead but subsys locked Any one know how to solve this and cause of this error ?

Also

• Restarting
• Starting
• And Stopping of MySQL

is Giving Output as: FAILED
But PHP is working fine. I've tested the phpinfo(); for Demo.
I've installed MySQL in /usr/local/mysql/bin. Can Anyone Help me in this ? Any help is appreciated.

Thanks in advance.

Answer 1

first,make sure that /etc/init.d/mysqld is running from /usr/local/mysql/bin then,kill mysqld ,delete the lock file and restart it.

Answer 2

1. tail /var/log/mysqld.log to check the error log

2. then do the following actions:

   rm /var/lock/subsys/mysqld chown -R mysql.mysql /var/run/mysqld

Answer 3

i use command kill, step by step:

1. use command service mysqld status for find PID mysqld
2. kill -9 PID
3. use command service mysqld status again for find PID mysqld
4. kill -15 PID
5. check again with command service mysqld status , check until the PID dead OR subsys locked
6. use command service mysqld start

Answer 4

I had this problem with my OTRS server after I tried to update a to large package.

The solution was:

copy for safty:

cp /var/lock/subsys/mysqld /root/mysqld

than delete it

rm /var/lock/subsys/mysqld

than close all services that depends on mysql:

service httpd stop
service otrs stop

after that:

service mysqld restart
service httpd restart
service otrs restart

System is CentOS 6.x

Answer 5

service mysqld restart

Simply restarting the mysqld worked fro me on Centos.

Answer 6

This (and all sorts of other weird errors) can also happen if you have a full disk. In my case, my /var partition had filled up. Freeing up space allowed mysqld to restart again.