Page 1 of 1
MySQL Client does not support authentication protocol ...
Posted: Wed Dec 21, 2005 10:37 am
by rembrandt
Hello,
After a full upgrade of my RH 9.0/PSA7.5.4 machine, with all packages of php (4.4.1-) and MySQL (4.1.15-1) on some sites my clients get this message:
Code: Select all
ERROR: Client does not support authentication protocol requested by server; consider upgrading MySQL client
I´ve tried searching google and here for a solution, but can´t find it anywhere, does any1 here got some answers/solutions for me?
Best regards
Posted: Wed Dec 21, 2005 6:29 pm
by Troy McClure
If I remember correctly this has something to do with the fact that mysql 4.4.1 uses a different password algorithm. You have to either change the passwords in mysql from the command line (this is how I fixed mine) or I think you can put 'old_passwords = 1' in my.cnf without the quotes (this way seems easier, but I'm not sure it works). Don't forget to restart mysql!
Posted: Thu Dec 22, 2005 8:08 am
by rembrandt
The problems are getting worse by the minute it seems....
After a complaint i´ve tried to reproduce what went wrong and yes: there is a MAJOR problem, here´s what i did:
Gat a fresh copy of Wordpress, installed it as instructed, after i was done, this error message appeared: "Error establishing a database connection". So this time i know i´m screwed.... please -any- assistance would be -very much- appreciated!
Best regards.
Posted: Thu Dec 22, 2005 9:23 am
by rembrandt
The problems are getting worse by the minute ... i think it´s best to roll back to the previous version of MySQL (4.0.25).
Is it save to roll back from 4.1.15 to 4.0.25? If not, please: help!?
Best regards.
Posted: Fri Dec 23, 2005 11:37 am
by scott
Yep, should be just fine to roll back to 4.0.25.
Posted: Fri Dec 23, 2005 2:02 pm
by breun
I don't think your problems got worse. You didn't use old_passwords=1, so your passwords aren't used correctly. Therefor wordpress can't connect to the database. Just use old_passwords and you should be fine. This has been mentioned on the forum a lot of times.
Posted: Fri Dec 23, 2005 3:49 pm
by rembrandt
breun wrote:I don't think your problems got worse. You didn't use old_passwords=1, so your passwords aren't used correctly.
That seems to be the problem indeed. old_passwords=1 is now added 2 my.cnf.
Posted: Mon Jan 09, 2006 9:12 pm
by AlleyKat
I've solved this - at least temporarily - by following
http://dev.mysql.com/doc/refman/5.0/en/old-client.html
(the UPDATE mysql.user part). It's time I update my php mysql client I guess?