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_m ysql.inc:1 psaerror(string "Unable to query: Unknown column 'Show_db_priv' in 'field list'") 1: /usr/local/psa/admin/plib/ class.Data Base.php3: 2 database_mysql->useradd(st ring "thierry", string "abc123", string "plain") 2: /usr/local/psa/admin/htdoc s/domains/ databases/ db_usr_edi t.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?
Unable to query: Unknown column 'Show_db_priv' in 'field list'
0: /usr/local/psa/admin/plib/
-
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?
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'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
ASKER
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(
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(
ASKER
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.
-> 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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