Krdytkyu

It randomly broke yesterday(not starting up any more) and I don't know how to fix it.

When I run:

sudo service mysql start

It gives this error:

Job for mysql.service failed because the control process exited with error 

code. See "systemctl status mysql.service" and "journalctl -xe" for details.

Output of systemctl status mysql.service:

● mysql.service - MySQL Community Server

   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)<br>

   Active: inactive (dead) (Result: exit-code) since Mon 2016-09-05 15:10:31 CEST; 43s ago<br>

  Process: 6515 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exited, status=1/FAILURE)<br>

Sep 05 15:10:31 vps310084 systemd[1]: mysql.service: Service hold-off time over, scheduling restart.<br>

Sep 05 15:10:31 vps310084 systemd[1]: Stopped MySQL Community Server.<br>

Sep 05 15:10:31 vps310084 systemd[1]: mysql.service: Start request repeated too quickly.<br>

Sep 05 15:10:31 vps310084 systemd[1]: Failed to start MySQL Community Server.<br>

Sep 05 15:10:33 vps310084 systemd[1]: mysql.service: Start request repeated too quickly.<br>

Sep 05 15:10:33 vps310084 systemd[1]: Failed to start MySQL Community Server.

Output of journalctl -xe:

Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel**

--

-- Unit mysql.service has failed.

--

-- The result is failed. 

Sep 05 15:14:56 vps310084 systemd[1]: mysql.service: Unit entered failed state. 

Sep 05 15:14:56 vps310084 systemd[1]: mysql.service: Failed with result 'exit-code'.

Sep 05 15:14:56 vps310084 systemd[1]: mysql.service: Service hold-off time over, scheduling restart. 

Sep 05 15:14:56 vps310084 systemd[1]: Stopped MySQL Community Server.

-- Subject: Unit mysql.service has finished shutting down<br>

-- Defined-By: systemd

-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel

--

-- Unit mysql.service has finished shutting down. 

Sep 05 15:14:56 vps310084 systemd[1]: mysql.service: Start request repeated too quickly. 

Sep 05 15:14:56 vps310084 systemd[1]: Failed to start MySQL Community Server.

-- Subject: Unit mysql.service has failed

-- Defined-By: systemd

--

-- Unit mysql.service has failed.

--

-- The result is failed.

the systemctl startup script for Mysql is failing to run this command
/usr/share/mysql/mysql-systemd-start pre

this doesn't do much other than sanity check your environment using the following shell code :

sanity () {

  if [ ! -r /etc/mysql/my.cnf ]; then

    echo "MySQL configuration not found at /etc/mysql/my.cnf. Please create one."

    exit 1

  fi



  if [ ! -d /var/lib/mysql ] && [ ! -L /var/lib/mysql ]; then

    echo "MySQL data dir not found at /var/lib/mysql. Please create one."

    exit 1

  fi



  if [ ! -d /var/lib/mysql/mysql ] && [ ! -L /var/lib/mysql/mysql ]; then

    echo "MySQL system database not found. Please run mysql_install_db tool."

    exit 1

  fi

}

if you run it directly via sudo you should get one of those error messages , please follow its suggestions and try again untill it works.

This isn't a random breakage this is missing files , check the bash_history of the root user and any user who can sudo.