MySQL Server Not Restarting

Mick Denton

Registered
Feb 11, 2016
1
0
1
UK
cPanel Access Level
Root Administrator
Can anyone help?

We are unable to restart the MySQL server and receive this log.

Code:
Waiting for “mysql” to start ……………failed.

Service Error
(XID f42v85) The “mysql” service failed to start.

Startup Log
Starting MySQL. ERROR! The server quit without updating PID file (/var/lib/mysql/vps.example.co.uk.pid).

Log Messages
160210 15:33:31 mysqld_safe mysqld from pid file /var/lib/mysql/vps.example.co.uk.pid ended
/usr/sbin/mysqld[0x862e61]
/usr/sbin/mysqld[0x8626d1]
/usr/sbin/mysqld[0x91c39e]
/usr/sbin/mysqld[0x91c16f]
/usr/sbin/mysqld[0x8616d1]
/usr/sbin/mysqld[0x86bee5]
/usr/sbin/mysqld[0x86baec]
/usr/sbin/mysqld[0x86f603]
/usr/sbin/mysqld[0x85936a]
/usr/sbin/mysqld[0x8d5f19]
160210 15:33:31 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
160210 15:33:25 mysqld_safe mysqld from pid file /var/lib/mysql/vps.example.co.uk.pid ended
/usr/sbin/mysqld[0x862e61]
/usr/sbin/mysqld[0x8626d1]
/usr/sbin/mysqld[0x91c39e]
/usr/sbin/mysqld[0x91c16f]
/usr/sbin/mysqld[0x8616d1]
/usr/sbin/mysqld[0x86bee5]
/usr/sbin/mysqld[0x86baec]
/usr/sbin/mysqld[0x86f603]
/usr/sbin/mysqld[0x85936a]
/usr/sbin/mysqld[0x8d5f19]

mysql has failed. Contact your system administrator if the service does not automagically recover.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,909
2,222
463
Hello :)

Could you let us know the output to /var/lib/mysql/$hostname.err when MySQL fails to start?

Thank you.