MySQL fails to start: mysql.user table is damaged

Created:

2017-03-03 13:56:54 UTC

Modified:

2017-08-14 06:02:12 UTC

5

Was this article helpful?


Have more questions?

Submit a request

MySQL fails to start: mysql.user table is damaged

Applicable to:

  • Plesk for Linux

Symptoms

MySQL has been upgraded and now fails to start.

The following error appears in /var/log/mysqld.log when trying to start MySQL:

CONFIG_TEXT: [ERROR] Fatal error: mysql.user table is damaged. Please run mysql_upgrade.

Plesk is not accessible: 

PLESK_INFO: ERROR: Zend_Db_Adapter_Exception: SQLSTATE[HY000] [2002] No such file or directory
Additionally, an exception has occurred while trying to report this error: Zend_Exception
No entry is registered for key 'translate' (Abstract.php:144)

Cause

Previously, MySQL 5.1 was upgraded to 5.5 without running mysql_upgrade

Resolution

  1. Connect to the server using SSH.
  2. Add skip-grant-tables in /etc/my.cnf file under [mysqld] section
  3. Start mysql service:

    # service mysqld start

  4. Run the upgrade:

    # mysql_upgrade

  5. Remove skip-grant-tables from /etc/my.cnf file
  6. Restart mysql:

    # service mysqld restart

Have more questions? Submit a request
Please sign in to leave a comment.