If you have plesk-based hosting sometimes you get very scary errors which look like your server is gone and your quite a dozen of sites are totally dead.
Table 'mysql.servers' doesn't exist
shows up after you have upgraded mysql through the atomic repo with yum and now you cannot create user databases under domains.
All you have to do is to create a table under mysql database.
# go with ssh to your server ssh your_user@your_server.com Password: mysql -u admin -p # normally it will require the same password as plesk login Password: # select "mysql" database mysql >use mysql;
Execute the below code. You are done.
Server_namechar(64) NOT NULL,
Hostchar(64) NOT NULL,
Dbchar(64) NOT NULL,
Usernamechar(64) NOT NULL,
Passwordchar(64) NOT NULL,
Portint(4) DEFAULT NULL,
Socketchar(64) DEFAULT NULL,
Wrapperchar(64) NOT NULL,
Ownerchar(64) NOT NULL, PRIMARY KEY (
Server_name) ) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='MySQL Foreign Servers table';
plesk really sucks, people, will surely change it for something else.
Great!!! With you tips I have solved that big problem thai I have from many week on a VPS. Thank a lot!!!