1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice

MySQL 4 problem

Discussion in 'Plesk for Linux - 8.x and Older' started by fdomartin, Jan 30, 2005.

  1. fdomartin

    fdomartin Guest

    I updated MySQL 4.0.23a from ART and I have this problem when I make a new user from a database on Plesk 7.5.1

    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 "smf", string "12345", string "plain")
    2: /usr/local/psa/admin/htdocs/domains/databases/db_usr_edit.php3:2 database->adduser(string "smf", string "12345")
  2. fdomartin

    fdomartin Guest

    I was found the answer on ART forum ;)

    Run this:

    mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow`
  3. chrander

    chrander Guest

    I also utilized ART's yum update to upgrade my MySQL and encountered the same error. Here is one solution I found after browsing through various forums:

    Make sure the mysql service is running and run the following command:
    mysql_fix_privilege_tables --user=admin --password=`cat /etc/psa/.psa.shadow`

    If I remember correctly you will receive several error messages that are benign in nature and hence can be ignored.

    I'm not an expert on MySQL so I'm not in a position to offer a comprehensive explanation of why this command works or if it is the perfect solution for your problem, so please don't try it out on a production server without getting a second opinion.

    --Oh well, it looks like the solution was found while I was drafting this post...
  4. Mirco@

    Mirco@ Basic Pleskian

    Aug 1, 2001
    Likes Received:
    Perfectly fine