MySQL authentication problem

[ChipMonk]

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?

 

[ShadowMan@]

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.

 

[ChipMonk]

I didnt run any script after the update.

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

 

[ShadowMan@]

Yes, and on ART's forum, user Griffith was having the same problem (different OS, but same problem with newly created databases/users) and he was able to solve it by using

set password for user@localhost = OLD_PASSWORD('password');

http://atomicrocketturtle.com/forum/viewtopic.php?p=1750&sid=6c9d7d5a3f0669b7ce28743ed7c2357e

 

[ChipMonk]

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.

 

[bram]

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

 

[rank1st]

Thanks Bram,

This worked for me after all else failed.