Link to home
Start Free TrialLog in
Avatar of kaeonthibe
kaeonthibe

asked on

Unable to query: Unknown column 'Show_db_priv' in 'field list'

I'm trying to add a database user in my Plesk and I've got this error:

Unable to query: Unknown column 'Show_db_priv' in 'field list'

0: /usr/local/psa/admin/plib/database_mysql.inc:1 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 "thierry", string "abc123", string "plain") 2: /usr/local/psa/admin/htdocs/domains/databases/db_usr_edit.php3:2 database->adduser(string "thierry", string "abc123")
 
-

I've done - /etc/init.d/mysqld condrestart, /etc/init.d/mysqld restart, /etc/init.d/psa stopall, /etc/init.d/psa start

But none of those works...

What do I have to... How can I create the Show_db_priv field?
Avatar of Ravi Goru
Ravi Goru
Flag of India image


Hi  Kaeonthibe ..

can u give us more details.. like

the version of MySQL you are using .. ,

and how are u trying to create users  ..??


try adding users  using mysql and GRANT ..

i mean somthing like this ..

mysql --user=root mysql

GRANT ALL PRIVILEGES ON some_database TO user@localhost
IDENTIFIED BY 'some_password' WITH GRANT OPTION;


and try using that account .. and revert back to us with ur .. difficulties.. !!

best of luck ..

RaviGoru
Avatar of kaeonthibe
kaeonthibe

ASKER

I'm using mysql 4.0.21
I'm trying to creat users with Plesk 7.1

And I don't know how to use the mysql command that you writed.

I guess .. Plesk 7 uses mysql 3.23.8 ..  or posgres 7.2.4 ..

btw.. there are some differences in mysql 3.23. and mysql 4 +  and for manipulateing those differences there are some scripts available..

anyway.. the simplest procedure is .. to try using the recommended version of databases..!!

let me know.. what r u interested in ..?

RaviGoru

Downgrade to mysql 3.23...

Because Pleslk 7 Reloaded doesn't work with MySQL 4 on a Red Hat 9 OS

How can I downgrade now to mysql 3.23?

:o(
Everything is okay now - I've found this file... MySQL 4.0 can Work on Plesk 7 :o)

-> http://www.analysisandsolutions.com/code/mysql_fix_privilege_tables_323_to_40.sql

I'm able now to create a database user.

good ..  u have done the right thing,

keep it up..!!
ASKER CERTIFIED SOLUTION
Avatar of ee_ai_construct
ee_ai_construct
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial