URGENT - Cannot Create DB Users

[Ben_P]

Hello,

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.

 

[hardweb]

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.

 

[Ben_P]

It worked, thank you very much