Question

Mysql doesn't start, no logs either

Mysql doesn’t start, no logs either. systemctl status mysql.service - returns


ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)

systemd[1]: mysql.service: Control process exited, code=exited status=1


Is there any way to repair or reset mysql from this state?


Submit an answer


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!

Sign In or Sign Up to Answer

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

alexdo
Site Moderator
Site Moderator badge
July 27, 2022

Hello there,

Have you recently made any changes to the MySQL configuration or any general changes on the droplet? If you examine the server’s resource usage is there anything weird you can spot on?

Additionally, you can check /var/log/syslog for any references to the MySQL service that can help to resolve the issue.

Regards

KFSys
Site Moderator
Site Moderator badge
July 27, 2022

Hi @gja,

After you try and start it, once it fails type in:

journalctl -xe

The error should be seen there.

Additionally, are you sure there are no errors in your error log? If everything is configured properly, the errors should be there.

Try DigitalOcean for free

Click below to sign up and get $200 of credit to try our products over 60 days!

Sign up