1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

mysql.servers' doesn't exist

Discussion in 'Plesk for Windows - 8.x and Older' started by GurdeepS, Apr 17, 2011.

  1. GurdeepS

    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

    Gurdeep Singh
  2. GurdeepS

    GurdeepS Guest

    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`)
    COMMENT='MySQL Foreign Servers table';

    I hope that helps someone out there!