Error ‘Table ‘mysql.servers’ doesn’t exist”

Posted on by Seemab Saleem

After Plesk update or with recently set up Plesk , if you are not able to set the security passwords for the new database users or not able to do any type of action with the data source users and MySQL error log shows:

[ERROR] Can’t open and lock privilege tables: Table ‘mysql.servers’ doesn’t exist

Then here are actions which could be referred:

Login to MySQL with admin privileges

#mysql -uadmin -p`cat /etc/psa/.psa.shadow` -h localhost

Go into MySQL database

mysql> use mysql;

Create server table

 mysql> CREATE TABLE `servers` (
`Server_name` char(64) NOT NULL,
`Host` char(64) NOT NULL,
`Db` char(64) NOT NULL,
`Username` char(64) NOT NULL,
`Password` char(64) NOT NULL,
`Port` int(4) DEFAULT NULL,
`Socket` char(64) DEFAULT NULL,
`Wrapper` char(64) NOT NULL,
`Owner` char(64) NOT NULL,
PRIMARY KEY (`Server_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8
COMMENT='MySQL Foreign Servers table';

‘Server’ table is created.
Now you should be able to operate the required database.