MySQL Client does not support authentication protocol ...

General Discussion of atomic repo and development projects.

Ask for help here with anything else not covered by other forums.
rembrandt
Forum User
Forum User
Posts: 27
Joined: Sat Oct 29, 2005 7:26 am
Location: Netherlands
Contact:

MySQL Client does not support authentication protocol ...

Unread post 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
Troy McClure
Forum Regular
Forum Regular
Posts: 196
Joined: Tue May 10, 2005 1:24 pm

Unread post 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!
rembrandt
Forum User
Forum User
Posts: 27
Joined: Sat Oct 29, 2005 7:26 am
Location: Netherlands
Contact:

Unread post 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.
rembrandt
Forum User
Forum User
Posts: 27
Joined: Sat Oct 29, 2005 7:26 am
Location: Netherlands
Contact:

Unread post 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.
scott
Atomicorp Staff - Site Admin
Atomicorp Staff - Site Admin
Posts: 8355
Joined: Wed Dec 31, 1969 8:00 pm
Location: earth
Contact:

Unread post by scott »

Yep, should be just fine to roll back to 4.0.25.
breun
Long Time Forum Regular
Long Time Forum Regular
Posts: 2813
Joined: Sat Aug 20, 2005 9:30 am
Location: The Netherlands

Unread post 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.
rembrandt
Forum User
Forum User
Posts: 27
Joined: Sat Oct 29, 2005 7:26 am
Location: Netherlands
Contact:

Unread post 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.
AlleyKat
Forum User
Forum User
Posts: 12
Joined: Fri Dec 30, 2005 7:35 am

Unread post 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?
Post Reply