Problems starting MySQL server

October 30, 2019 258 views
MySQL Ubuntu 18.04

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.

1 Answer

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

Have another answer? Share your knowledge.