asked on

The “mysql” service failed to start.

Suddenly MySQL died and cannot start again. All Drupal sites are down. I had this some 2 weeks ago and was unable to figure out how to fix, so had to restore the server (as per support). This is what I am getting when trying to start mysql:
-----------------------------------------------------------------------------------------
Restarting MySQL Server
Waiting for “mysql” to start …………
…failed.

Service Error
The “mysql” service failed to start.

Startup Log
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/ip-192-169-222-111.secureserver.net.pid).

Log Messages
150607 10:04:57 mysqld_safe mysqld from pid file /var/lib/mysql/ip-192-169-222-111.secureserver.net.pid ended
InnoDB: To fix the problem and start mysqld:
150607 10:04:56 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150607 10:04:51 mysqld_safe mysqld from pid file /var/lib/mysql/ip-192-169-222-111.secureserver.net.pid ended
InnoDB: To fix the problem and start mysqld:
150607 10:04:50 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150607 10:04:45 mysqld_safe mysqld from pid file /var/lib/mysql/ip-192-169-222-111.secureserver.net.pid ended
InnoDB: To fix the problem and start mysqld:

mysql has failed. Please contact your system administrator if the service does not automagically recover.
-----------------------------------------------------------------------------------------
How can I fix this and get MySQL running again. Please help !!!
Thannk.

arnold

Check directory permissions
/var/lib/mysql and the contents there in.
It should be owned by MySQL:MySQL.

ASKER CERTIFIED SOLUTION

Milind Koyande

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial