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

URGENT - Cannot Create DB Users

Discussion in 'Plesk for Linux - 8.x and Older' started by Ben_P, Jan 17, 2005.

  1. Ben_P

    Ben_P Guest


    I cannot create db users thru plesk for some reason. Its ok for me obviosuly because i can use SSH but my clients cannot.

    I tried to add a user "Testuser" password "Testpass" and i got the following error:

    Unable to query: Unknown column 'Show_db_priv' in 'field list'
    0: /usr/local/psa/admin/plib/database_mysql.inc:2 psaerror(string "Unable to query: Unknown column 'Show_db_priv' in 'field list'")
    1: /usr/local/psa/admin/plib/class.DataBase.php3:2 database_mysql->useradd(string "testname", string "testpass", string "plain")
    2: /usr/local/psa/admin/htdocs/domains/databases/db_usr_edit.php3:2 database->adduser(string "testname", string "testpass")

    If anyboyd knows how to solve it that would be much appreciated, thank you so much.
  2. hardweb

    hardweb Guest

    Most likely you use Mysql 4 with old grant tables. Execute the command:

    mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow`

    This should fix your issue.
  3. Ben_P

    Ben_P Guest

    It worked, thank you very much :)