- Plesk for Linux
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]  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)
Previously, MySQL 5.1 was upgraded to 5.5 without running
- Connect to the server using SSH.
- Add skip-grant-tables in
- Start mysql service:
# service mysqld start
- Run the upgrade:
- Remove skip-grant-tables from
- Restart mysql:
# service mysqld restart