logesh
By:
logesh

MySQL Not Starting Up - Got Freezed while Upgrading to MySQL 5.6

June 25, 2015 1.3k views
MySQL Apache

I attempted to upgrade MySQL from 5.5 to 5.6 via WHM. It got stuck at the middle and after that I am unable to restart the MySQL.

Whenever I attempt to restart the MySQL, the output is

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/linux001.annaiservers.com.pid).

Log Messages
150625 10:18:02 mysqld_safe mysqld from pid file /var/lib/mysql/linux001.annaiservers.com.pid ended
/usr/sbin/mysqld[0x5926a5]
/usr/sbin/mysqld[0x59b35d]
/usr/sbin/mysqld[0x6e7c51]
/usr/sbin/mysqld[0x96c77d]
/usr/sbin/mysqld[0xa236b2]
/usr/sbin/mysqld[0xaa5dfa]
/usr/sbin/mysqld[0xaa41e4]
150625 10:18:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150625 10:17:55 mysqld_safe mysqld from pid file /var/lib/mysql/linux001.annaiservers.com.pid ended
/usr/sbin/mysqld[0x5926a5]
/usr/sbin/mysqld[0x59b35d]
/usr/sbin/mysqld[0x6e7c51]
/usr/sbin/mysqld[0x96c77d]
/usr/sbin/mysqld[0xa236b2]
/usr/sbin/mysqld[0xaa5dfa]
/usr/sbin/mysqld[0xaa41e4]
150625 10:17:54 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
150625 10:17:48 mysqld_safe mysqld from pid file /var/lib/mysql/linux001.annaiservers.com.pid ended
/usr/sbin/mysqld[0x5926a5]
/usr/sbin/mysqld[0x59b35d]
/usr/sbin/mysqld[0x6e7c51]

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

How can I recover the MySQL ?

1 Answer

Welcome to DigitalOcean

I would recommend you to reinstall MySQL.

sudo cp -r /etc/mysql /etc/mysql_old
sudo apt-get purge mysql-server
sudo apt-get autoremove
sudo apt-get install mysql-server php5-mysql
service mysql start

You even have your old Databases :-)

If everything works fine show me some love and click the hearth

Have another answer? Share your knowledge.