?
Solved

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

Posted on 2004-11-18
8
Medium Priority
?
474 Views
Last Modified: 2013-12-06
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?
0
Comment
Question by:kaeonthibe
  • 3
  • 3
7 Comments
 
LVL 3

Expert Comment

by:Ravi Goru
ID: 12612711

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
0
 

Author Comment

by:kaeonthibe
ID: 12613095
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.
0
 
LVL 3

Expert Comment

by:Ravi Goru
ID: 12614489

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

0
Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

 

Author Comment

by:kaeonthibe
ID: 12619147
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(
0
 

Author Comment

by:kaeonthibe
ID: 12619557
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.
0
 
LVL 3

Expert Comment

by:Ravi Goru
ID: 12622818

good ..  u have done the right thing,

keep it up..!!
0
 

Accepted Solution

by:
ee_ai_construct earned 0 total points
ID: 12641733
Question answered by asker or dialog valuable.
Closed, 250 points refunded.
ee_ai_construct (replacement part #xm34)
Community Support Admin
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In my business, I use the LTS (Long Term Support) versions of Linux. My workstations do real work, and so I rarely have the patience to deal with silly problems caused by an upgraded kernel that had experimental software on it to begin with from a r…
The purpose of this article is to show how we can create Linux Mint virtual machine using Oracle Virtual Box. To install Linux Mint we have to download the ISO file from its website i.e. http://www.linuxmint.com. Once you open the link you will see …
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
Suggested Courses
Course of the Month17 days, 1 hour left to enroll

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question