• Plesk Uservoice will be deprecated by October. Moving forward, all product feature requests and improvement suggestions will be managed through our new platform Plesk Productboard.
    To continue sharing your ideas and feedback, please visit features.plesk.com

MySQL authentication problem

C

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


Could not connect to database: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Check your database settings in the config.php file.

I have the following version of mySQL

mysql 4.1.14-1.rhfc2.art

what I am missing?
 
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
script?

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.
 
I didnt run any script after the update.

and my old databases are working very fine, just i cant get new one worked.
 
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.
 
Hello,

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,

bram
 
Back
Top