MySQL Daemon failed to start error solution

MySQL Daemon failed to start error solution

A few days ago, we found that the published website could not be used for registration and logging into these activities, but accessing the pages was normal. So we started to troubleshoot the problem. First, we restarted Jenkins, but there were errors every time we restarted, so we had to restart the server. There were many services that needed to be restarted when restarting the server, one of which was MySQL.

First I tried to start the service with the command: service mysql start, but it prompted:

MySQL Daemon failed to start

When this problem first occurred, I was confused, and then I started to check and found all kinds of things. Then I saw a blog post about checking the log, so I went to this path to check the log: /var/log/mysqld.log

Open the log file and find the following prompt:

You can see the prompt: No space left on device

So use the command: df -lh to check the remaining disk space

I found that the disk space was used up, so I deleted some useless files, freed up several GB of space, and re-entered the command: service mysql start, and the startup was completed.

From this incident, I remind myself that next time I encounter a problem, the first thing I should do may not be to check Baidu or Google, but to check the log. This shows how important logs are in the process of making and using our software.

Thank you for reading, I hope it can help you, thank you for your support of this site!