Bobcares

WeSupport

Call Us! 1-800-383-5193
Call Us! 1-800-383-5193
Call Us! 1-800-383-5193

Need Help?

Emergency Response Time custom

Our experts have had an average response time of 11.55 minutes in January 2021 to fix urgent issues.

We will keep your servers stable, secure and fast at all times for one fixed price.

MySQL is not running – Let’s resolve it

by | Feb 18, 2021

The error ‘MySQL is not running’ in cPanel is one of the common error that we come across. Yes, we do understand this to be very annoying.

Generally, this error causes if MySQL is not stopped properly. This means when a systemd sends a command for the MySQL to start, the MySQL launches, and then it populates a lock for the subsystem. But then it stops with an error.

Here at Bobcares, we often receive requests to resolve the MySQL errors as a part of our Server Management Services for web hosts and online service providers.

Today, let us see how efficiently our Support Engineers fix this MySQL error.

 

How we fix MySQL is not running problem?

Now, let us see how our Support Engineers fix this error in cPanel.

 

1. Removing the lock file to fix MySQL error

One of our customers approached telling us that MySQL was not working well.

Our Support Engineers started to troubleshoot the error by checking the MySQL status using the below command

# service mysql status
MySQL is not running, but lock file (/var/lock/subsys/mysql[FAILED]

And the above was the status of MySQL telling us that MySQL was not running. So our Support Engineers ran the below command to remove the lock file.

rm /var/lock/subsys/mysql

Then, we restarted the MySQL service using the below command:

# service mysqld restart

This fixed the error.

 

2. MySQL stops running if tables crash

Another reason for this error to occur is due to the database tables crashing. Normally, the below message displays in the MySQL error logs.

MyISAM-table '/var/lib/mysql/dbname/table_name.MYI' is marked as crashed and should be repaired

We can fix this problem by repairing the database and the database tables using the below commands:

# myisamchk <database> <server>
# mysqlcheck -r <database> <postname>

Then, we restart the MySQL service using the command.

# service mysqld restart

[Need any further assistance in fixing MySQL error? – We’ll help you]

 

Conclusion

In short, this MySQL error occurs due to many reasons that include stopping MySQL improperly, tables crashing and so on. Today, we saw how our Support Engineers fix this MySQL error.

PREVENT YOUR SERVER FROM CRASHING!

Never again lose customers to poor server speed! Let us help you.

Our server experts will monitor & maintain your server 24/7 so that it remains lightning fast and secure.

GET STARTED

var google_conversion_label = "owonCMyG5nEQ0aD71QM";

0 Comments

Submit a Comment

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

Categories:

Tags: