Installation or upgrade failed when mysql.servers table is missing

Created:

2016-11-16 12:59:30 UTC

Modified:

2017-08-08 13:11:00 UTC

6

Was this article helpful?


Have more questions?

Submit a request

Installation or upgrade failed when mysql.servers table is missing

Applicable to:

  • Plesk for Windows
  • Plesk for Linux

Symptoms

Plesk or its components installation / upgrade failed with the error in the /tmp/autoinstaller3.log :

ERROR 1146 (42S02) at line 1: Table 'mysql.servers' doesn't exist

ERROR while trying to (to Convert MySQL DB users passwords to new format), the query was: UPDATE mysql.user m
INNER JOIN psa.db_users u ON (m.User = u.login)
INNER JOIN psa.accounts a ON (u.account_id = a.id)
INNER JOIN psa.data_bases d ON (u.db_id = d.id)
SET m.Password = PASSWORD(a.password)
WHERE d.type = 'mysql' AND a.type = 'plain';
FLUSH PRIVILEGES;
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again

Cause

MySQL table mysql.servers does not exist

Resolution

Run the following command for repairing MySQL table:

# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin -T --debug-check mysql

For the versions of MySQL Server below 5.1 you can use following method:

  1. Update all the mysql privilege tables to be usable by the current version of MySQL

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_fix_privilege_tables --user=admin --verbose
  2. Check for mysql.servers table in the mysql database:

    # grep "servers" /usr/share/mysql/mysql_system_tables.sql
    CREATE TABLE IF NOT EXISTS servers ( Server_name char(64) NOT NULL DEFAULT '', Host char(64) NOT NULL DEFAULT '', Db char(64) NOT NULL DEFAULT '', Username char(64) NOT NULL DEFAULT '', Password char(64) NOT NULL DEFAULT '', Port INT(4) NOT NULL DEFAULT '0', Socket char(64) NOT NULL DEFAULT '', Wrapper char(64) NOT NULL DEFAULT '', Owner char(64) NOT NULL DEFAULT '', PRIMARY KEY (Server_name)) CHARACTER SET utf8 comment='MySQL Foreign Servers table';
  3. Restore the table by executing the following query:

    # grep "servers" /usr/share/mysql/mysql_system_tables.sql | MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin mysql

Additional information

#213364309 Unable to log in to Plesk: saved admin password is incorrect

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