in MySQL

unable to start MySQL service after reboot (2)

1 Star2 Stars3 Stars4 Stars5 Stars (15 votes, average: 4.87 out of 5)

There are plenty of possible reasons to to start MySQL service after reboot, but if you did not make any change in your/etc/my.cnf and you can not start MySQL service after rebooting you CentOS server, in this case there is a known error with CentOS 5.6, 6 and above where upon reboot the MySQL socket in not closed causing MySQL not to start.

There is a workaround to resolve this issue that you can perform on your server. Further information on this bug can be found via the Red Hat and MySQL bug trackers.

So to fix that, log in to your server via SSH as the root user, and run the following command to remove the socket file:

rm -vf /var/lib/mysql/mysql.sock

You can paste into an SSH widow using the right mouse button.
then restart the mySQL service using the following command:

/etc/init.d/mysql restart

part 1

Related Posts

Written By:

Blog for everything about hosting, website, server and technical support

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.