Cannot start MySQL service.

Refers to:

  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 13:02:48 UTC

Modified:

2016-12-21 19:49:38 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Cannot start MySQL service.

Symptoms

Cannot start MySQL service.

In logs I can see following error:

140414  4:55:45  InnoDB: Started; log sequence number 0 218873467
140414 4:55:46 [ERROR] /usr/libexec/mysqld: Table './mysql/user' is marked as crashed and should be repaired
140414 4:55:46 [ERROR] Fatal error: Can't open and lock privilege tables: Table './mysql/user' is marked as crashed and should be repaired
140414 04:55:46 mysqld_safe mysqld from pid file /var/run/mysqld/mysqld.pid ended

Cause

Corrupted table in mysql database.

Resolution

  1. Copy original files of mysql database:

    cp -rp /var/lib/mysql/mysql /root/mysql.orig
  2. Repaired database:

    /usr/bin/myisamchk -r /var/lib/mysql/mysql/*MYI
  3. Restart mysql service:

    /etc/init.d/mysqld restart
Have more questions? Submit a request
Please sign in to leave a comment.