mysql55-mysqld service on Linux showing "dead but pid file exists"
Problem Description :
ExpressionEngine not running and mysql55-mysqld service showing "dead but pid file exists"
Resolution :
This usually means the OS did not shutdown cleanly. From the GUI in Redhat/CentOS, under System > Administration > Services, the mysql55-mysqld service may show "dead but pid file exists". When you try to restart the mysql service you will receive a message "Another MySQL daemon already running with the same unix socket." In order to fix you have to move/backup the mysql.sock file (command below) and then start the mysql55-mysqld service from the Services GUI. This will create a new mysql.sock file which will then allow you to start up the database.
# mv /var/lib/mysql/mysql.sock /var/lib/mysql/mysql.sock.bak
Revision Date : 3/30/2016