Nikos Polizotis wrote:> Sent: Thursday, November 11, 2004 12:04 PM
>
> Unfortunately neither driver works for Mysql 4.1.7 .
>
> I get a " Client does not support authentication protocol requested by
> server; consider upgrading MySQL client (Mysql::Error)"  message when
> trying to connect as root to localhost with a password (mysql variable
> old_passwords is turned on as well).
>
> Any clues?

I just got over this one yesterday (thanks to the help on the Rails ML).

The short answer is that starting with 4.1.7 MySQL changed the way it hashes
passwords, so clients (like what is included in Rails) need to be updated to
use the new hash as well.

I reinstalled 4.1.7 without a root password and left the Rails database
config password blank. That worked for me.

Below is the response I got from Jason with a link to more info in the MySQL
site (which include numerous work-arounds).

Curt


-----Original Message-----
From: rails-bounces / lists.rubyonrails.org
[mailto:rails-bounces / lists.rubyonrails.org]On Behalf Of Jason Hoffman
Sent: Wednesday, November 10, 2004 6:47 PM
To: rails / lists.rubyonrails.org
Subject: Re: [Rails] MySQL Error


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1


>> Your server is 4.1.7 and it's likely that your client is not. This
>> error is what happens if you upgraded your server from 4.1.6gamma to
>> 4.1.7, but then left the client at 4.1.6gamma or lesser. Or if you
>> have
>> a 4.1.7 server that you are trying to talk to remotely with an old
>> client.
>
> That makes come sense as I just installed a new version of MySQL.
>
> So they really changed the authentication protocol in 4.1.7?

Yes in 4.1.x, you can read about the "Client does not support
authentication protocol" error here
http://dev.mysql.com/doc/mysql/en/Old_client.html

- - J