By logesh
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 ?
This textbox defaults to using Markdown to format your answer.
You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!
Accepted 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
Become a contributor for community
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
DigitalOcean Documentation
Full documentation for every DigitalOcean product.
Resources for startups and AI-native businesses
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
The developer cloud
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Get started for free
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.