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

Posted on 2004-11-18
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/ 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?
Question by:kaeonthibe
    LVL 3

    Expert Comment

    by:Ravi Goru

    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

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

    best of luck ..


    Author Comment

    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.
    LVL 3

    Expert Comment

    by:Ravi Goru

    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 ..?



    Author Comment

    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?


    Author Comment

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


    I'm able now to create a database user.
    LVL 3

    Expert Comment

    by:Ravi Goru

    good ..  u have done the right thing,

    keep it up..!!

    Accepted Solution

    Question answered by asker or dialog valuable.
    Closed, 250 points refunded.
    ee_ai_construct (replacement part #xm34)
    Community Support Admin

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Suggested Solutions

    SSH (Secure Shell) - Tips and Tricks As you all know SSH(Secure Shell) is a network protocol, which we use to access/transfer files securely between two networked devices. SSH was actually designed as a replacement for insecure protocols that sen…
    It’s 2016. Password authentication should be dead — or at least close to dying. But, unfortunately, it has not traversed Quagga stage yet. Using password authentication is like laundering hotel guest linens with a washboard — it’s Passé.
    Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
    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.

    755 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

    Need Help in Real-Time?

    Connect with top rated Experts

    23 Experts available now in Live!

    Get 1:1 Help Now