• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

mysql.servers' doesn't exist

G

GurdeepS

Guest
Hi Everyone,

I am using plesk 8.6 on windows 2003, Currently I have integrated Mysql 5.1 in plesk. while I am creating database user through plesk getting the below error, but user is successfully get created in mysql and I am able to access the database with the same user. I have also run "mysql_fix_privilege_tables.sql
" but the problem is same. Kindly look into this and revert back.

Add new database user failed: Can't execute FLUSH PRIVILEGES: MySql error 1146:Table 'mysql.servers' doesn't exist
---------------------- Debug Info -------------------------------
0: plib\DatabaseManagerMySQL.php:83
DatabaseManagerMySQL->addUserToDatabaseImpl(string 'tendy_test3', string '*********', string 'trendy_test2')
1: plib\DatabaseManager.php:163
DatabaseManager->createUser(object of type dbUser)
2: htdocs\domains\databases\db_usr_edit.php3:116

Regards
Gurdeep Singh
 
got the below solutions for the same

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!
 
Back
Top