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
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

MySQL authentication problem

Discussion in 'Plesk for Linux - 8.x and Older' started by ChipMonk, Oct 25, 2005.

  1. ChipMonk

    ChipMonk Guest

    Few weeks back I updated/upgraded my system using ART yum update.

    Everything else is working perfectly fine so far.

    But when i try to use mySQL, after setup it gives following error

    I have the following version of mySQL

    mysql 4.1.14-1.rhfc2.art

    what I am missing?
  2. ShadowMan@

    ShadowMan@ Guest

    Possibly 2 things:

    In my.cnf, you may have to set it for old_passwords (or old-passwords), and also did you run the /usr/bin/mysql_fix_privilege_tables

    For the old passwords, do a search on mysql.org, I don't remember the exact parameters right now. Has to do with password hashing.
  3. ChipMonk

    ChipMonk Guest

    I didnt run any script after the update.

    and my old databases are working very fine, just i cant get new one worked.
  4. ShadowMan@

    ShadowMan@ Guest

  5. ChipMonk

    ChipMonk Guest

    well, i checked the thread.

    I got no clue of any solution (maybe i skipped if it was there)

    I added the old_passwords=1 in my.conf file under /etc/

    but even after restarting the mysqld, same problem is there.

    i have three pending clients, plus my own forum site waiting for this thing to be cleared.
  6. bram

    bram Guest


    I fix this with the following solution:

    ssh login on server

    mysql -u admin -p (password = root password from plesk)

    SELECT Host, User, Password FROM mysql.user WHERE LENGTH(Password) > 16;

    It give a list of users who need the old password fix

    SET PASSWORD FOR USER765@localhost = OLD_PASSWORD("hello654');

    hello654 is the password for database user: USER765.

    Hope this help,

    kind regards,

  7. rank1st

    rank1st Guest

    Thanks Bram,

    This worked for me after all else failed.