mysql.service failed can't start

Virtualmin
1

Job for mysql.service failed because the control process exited with error code. See “systemctl status mysql.service” and “journalctl -xe” for details.

root@server1:~# systemctl status mysql.service
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
   Active: activating (start-post) (Result: exit-code) since Thu 2020-06-11 10:4
  Process: 2796 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
  Process: 2790 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exit
 Main PID: 2796 (code=exited, status=1/FAILURE);         : 2797 (mysql-systemd-s
   CGroup: /system.slice/mysql.service
           └─control
             ├─2797 /bin/bash /usr/share/mysql/mysql-systemd-start post
             └─2935 sleep 1

Jun 11 10:43:02 server1.nairanews.com.ng systemd[1]: mysql.service: Service hold
Jun 11 10:43:02 server1.nairanews.com.ng systemd[1]: Stopped MySQL Community Ser
Jun 11 10:43:02 server1.nairanews.com.ng systemd[1]: Starting MySQL Community Se
Jun 11 10:43:05 server1.nairanews.com.ng systemd[1]: mysql.service: Main process
...skipping...
● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: en
   Active: activating (start-post) (Result: exit-code) since Thu 2020-06-11 10:4
  Process: 2796 ExecStart=/usr/sbin/mysqld (code=exited, status=1/FAILURE)
  Process: 2790 ExecStartPre=/usr/share/mysql/mysql-systemd-start pre (code=exit
 Main PID: 2796 (code=exited, status=1/FAILURE);         : 2797 (mysql-systemd-s
   CGroup: /system.slice/mysql.service
           └─control
             ├─2797 /bin/bash /usr/share/mysql/mysql-systemd-start post
             └─2935 sleep 1

Jun 11 10:43:02 server1.nairanews.com.ng systemd[1]: mysql.service: Service hold
Jun 11 10:43:02 server1.nairanews.com.ng systemd[1]: Stopped MySQL Community Ser
Jun 11 10:43:02 server1.nairanews.com.ng systemd[1]: Starting MySQL Community Se
Jun 11 10:43:05 server1.nairanews.com.ng systemd[1]: mysql.service: Main process
2

It looks like you’ve installed a third party MySQL package (from the MySQL Community repos). Have you done everything you need to do to stop/disable and optionally migrate from the default database that was installed during Virtualmin installation? It is possible the default database server is already running.

3

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.