I’m trying to setup Open Game Panel on my droplet, and it needs a MySQL database. When I try to start it, I get:
Job for mysql.service failed because the control process exited with error code.
See "systemctl status mysql.service" and "journalctl -xe" for details.
Doing systemctl status mysql.service gives me:
● mysql.service - MySQL Community Server
Loaded: loaded (/lib/systemd/system/mysql.service; disabled; vendor preset: enabled)
Active: failed (Result: exit-code) since Wed 2019-10-30 20:27:18 UTC; 34s ago
Process: 2242 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)
Oct 30 20:27:18 colinvps systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Oct 30 20:27:18 colinvps systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
Oct 30 20:27:18 colinvps systemd[1]: Stopped MySQL Community Server.
Oct 30 20:27:18 colinvps systemd[1]: mysql.service: Start request repeated too quickly.
Oct 30 20:27:18 colinvps systemd[1]: mysql.service: Failed with result 'exit-code'.
Oct 30 20:27:18 colinvps systemd[1]: Failed to start MySQL Community Server.
Doing journalctl -xe gives me:
Oct 30 20:28:57 colinvps systemd[1]: mysql.service: Service hold-off time over, scheduling restart.
Oct 30 20:28:57 colinvps systemd[1]: mysql.service: Scheduled restart job, restart counter is at 5.
-- Subject: Automatic restarting of a unit has been scheduled
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Automatic restarting of the unit mysql.service has been scheduled, as the result for
-- the configured Restart= setting for the unit.
Oct 30 20:28:57 colinvps systemd[1]: Stopped MySQL Community Server.
-- Subject: Unit mysql.service has finished shutting down
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mysql.service has finished shutting down.
Oct 30 20:28:57 colinvps systemd[1]: mysql.service: Start request repeated too quickly.
Oct 30 20:28:57 colinvps systemd[1]: mysql.service: Failed with result 'exit-code'.
Oct 30 20:28:57 colinvps systemd[1]: Failed to start MySQL Community Server.
-- Subject: Unit mysql.service has failed
-- Defined-By: systemd
-- Support: http://www.ubuntu.com/support
--
-- Unit mysql.service has failed.
--
-- The result is RESULT.
I’ve messed with a bunch of stuff and nothing works.
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!
Hi @colp3505,
Try to restart your mysql and try to use fullstatus instead of status afterwards for the service
systemctl fullstatus mysql
I’ll recommend checking your mysql error_log, it should state why it’s having troubles starting up.
Other common issues come from a droplet being full, not enough inodes, corrupted innodb.
Regards, KDSys
Get paid to write technical tutorials and select a tech-focused charity to receive a matching donation.
Full documentation for every DigitalOcean product.
The Wave has everything you need to know about building a business, from raising funding to marketing your product.
Stay up to date by signing up for DigitalOcean’s Infrastructure as a Newsletter.
New accounts only. By submitting your email you agree to our Privacy Policy
Scale up as you grow — whether you're running one virtual machine or ten thousand.
Sign up and get $200 in credit for your first 60 days with DigitalOcean.*
*This promotional offer applies to new accounts only.