lsb mysql won't start

Discussion in 'ISPConfig 3 Priority Support' started by Tomislav Aurednik, Aug 9, 2017.

  1. Tomislav Aurednik

    Tomislav Aurednik Member HowtoForge Supporter

    my servers went down because of power failure. Now mysql won't start. I'm getting errors:
    ● mysql.service - LSB: Start and stop the mysql database server daemon
    Loaded: loaded (/etc/init.d/mysql; bad; vendor preset: enabled)
    Active: failed (Result: exit-code) since Wed 2017-08-09 09:38:05 CEST; 4min 15s ago
    Docs: man:systemd-sysv-generator(8)
    Process: 1607 ExecStart=/etc/init.d/mysql start (code=exited, status=1/FAILURE)

    Aug 09 09:37:35 pro2 mysqld[1983]: 170809 9:37:35 [ERROR] Can't open and lock privilege tables: Table 'mysql.servers' doesn't exist
    Aug 09 09:37:35 pro2 mysqld[1983]: 170809 9:37:35 [Note] Server socket created on IP: '::'.
    Aug 09 09:37:35 pro2 mysqld[1983]: 170809 9:37:35 [ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist
    Aug 09 09:37:35 pro2 mysqld_safe[2056]: mysqld from pid file /var/run/mysqld/mysqld.pid ended
    Aug 09 09:38:05 pro2 mysql[1607]: ...fail!
    Aug 09 09:38:05 pro2 systemd[1]: mysql.service: Control process exited, code=exited status=1
    Aug 09 09:38:05 pro2 systemd[1]: Failed to start LSB: Start and stop the mysql database server daemon.
    Aug 09 09:38:05 pro2 systemd[1]: mysql.service: Unit entered failed state.
    Aug 09 09:38:05 pro2 systemd[1]: mysql.service: Failed with result 'exit-code'.
    Aug 09 09:38:05 pro2 systemd[1]: Stopped LSB: Start and stop the mysql database server daemon.

    The only thing that google found is to delete the mysql and make a new install and this isn't a option for me!
    The /var/lib/mysql folder and all his subfolders have mysql:mysql permissions.
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

Share This Page