- Fedora -
SOOOO my continuing effort to upgrade my VPS server has lead me to a new error. This time in Plesk:
“Table ‘mysql.servers’ doesn’t exist”
I’m sure it has something to do with me upgrading mysql in my last post. It was an easy fix and here it is:
Google brought me to: http://forums.mysql.com/read.php?11,142598,188705#msg-188705
Step 1: SSH to your server
Step 2: Open mysql by typing:
mysql -u YOURUSERNAMEHERE -p
Make sure to put in your own username. When you hit enter, you’ll be asked for your mysql password.
Step 3: Use the mysql database:
USE mysql;
Step 4: Place this code in to create the table:
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';
I hope that helps someone out there!
