Error opening database in MySQL Front

Created:

2016-11-16 13:08:10 UTC

Modified:

2017-04-24 11:56:47 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Error opening database in MySQL Front

Applicable to:

  • Plesk 12.0 for Linux

Symptoms

  • Error when trying to open database in MySQL Front:

    Cannot load from mysql.proc the table is probably corrupted
  • The following errors might be found in mysqld.log on server restart:

    160928 15:15:09 [ERROR] Missing system table mysql.<table_name>; please run mysql_upgrade to create it
    160928 15:15:09 [ERROR] Native table 'performance_schema'.<table_name> has the wrong structure

Cause

MySQL database structure was not upgraded completely.

Resolution

Upgrade database structure: mysql_upgrade -u admin -p cat /etc/psa/.psa.shadow

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