Steps to resolve the error ‘Table ‘mysql.servers’ doesn’t exist”

After plesk upgrade  or  with newly installed plesk , if you are not able to set the passwords for the
new database users or not able to do any kind of activity with the database users and mysql error log shows
[ERROR] Can’t open and lock privilege tables: Table ‘mysql.servers’ doesn’t exist

Then here are steps which could be referred:

1)      Login to mysql with admin privileges

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

 

2) Go into mysql database

             mysql> use mysql;

3) 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’;

4) ‘Server’ table is created.

You should be able to operate the required database now.

  • 43 Los Usuarios han Encontrado Esto Útil
¿Fue útil la respuesta?

Artículos Relacionados

Can I use my domain name or must I use my IP address as the hostname for FTP?

Using your IP address (192.168.22.22  is an example IP address) is the preferred entry for...

Can you transfer my sites from my current host to my new VPS?

Yes. We will transfer all of your sites free* of charge and will assure that you experience no or...

Do you allow MP3 files? Do you allow streaming of videos?

Yes we do with our special plans at http://hostripples.in/avs-hosting.php

Do you support Cold Fusion?

We do not support or Cold Fusion on our shared hosting servers, however you are more than welcome...