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

Cannot add user to the database

Discussion in 'Plesk 9.x for Linux Issues, Fixes, How-To' started by wer0ckz, Jul 16, 2012.

  1. wer0ckz

    wer0ckz Guest

    0
     
    Hi guys. I'm trying to add a user to a specific database but i got an error mesasge:

    Error: Connection to the database server has failed:

    Table 'mysql.servers' doesn't exist

    See screenshot: http://postimage.org/image/gjt1kzidp/

    Any suggestions?

    Thanks in advanced
     
  2. abdi

    abdi Platinum Pleskian

    31
    18%
    Joined:
    May 14, 2006
    Messages:
    2,913
    Likes Received:
    60
    Usually after the upgrade there errors that arise with MySQL in Plesk while creating users, errors such as "Table 'mysql.servers' doesn't exist" to solve do the following:

    mysql -uadmin -p`cat /etc/psa/.psa.shadow` mysql

    Then RUN the following:

    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';

    That is all for now ...
     
Loading...