service mysqld status

mysqld dead but subsys locked

rm -f /var/lock/subsys/mysqld

service mysqld status

mysqld is stopped

/etc/init.d/mysqld start

Starting mysqld: [ OK ]