Article ID: 112290, created on Sep 15, 2011, last review on Jun 8, 2016

  • Applies to:
  • Plesk for Linux/Unix
  • Plesk for Windows


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

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

In addition you can see the following errors:

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 =
                            INNER JOIN psa.data_bases d ON (u.db_id =
            SET m.Password = PASSWORD(a.password)
            WHERE d.type = 'mysql' AND a.type = 'plain';
Check the error reason(see log file: /tmp/plesk_11.5.30_installation.log), fix and try again


MySQL table 'mysql.servers' does not exist.


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

After applying the solution above, you may encounter the issue described in KB#112492.

Search Words

ERROR: Failed to run the Yum utility.

Table 'mysql.servers' doesn't exist

update failed

ERROR while trying to (to Convert MySQL DB users passwords to new format)

a914db3fdc7a53ddcfd1b2db8f5a1b9c 29d1e90fd304f01e6420fbe60f66f838 56797cefb1efc9130f7c48a7d1db0f0c 85a92ca67f2200d36506862eaa6ed6b8

Email subscription for changes to this article
Save as PDF