can DBD::mysql handle the new mysql-4.1.0 authentication method?

can DBD::mysql handle the new mysql-4.1.0 authentication method?

am 03.12.2003 06:18:29 von Peter Selinger

Hi,

according to its changelog, mysql 4.1.0 introduced a "New more secure
client authentication based on 45-byte passwords in the user table."

I am dealing with a server which accepts *only* this new
authentication method; all old methods have been disabled because they
were not secure (unencrypted password was sent over the network, as
far as I know).

My problem is: I cannot get DBI / DBD::mysql to use this new method. I
have upgraded everything to the newest version, and I still get this
error message:

DBI connect('database=xxxx;host=yyyy,'zzzz',...) failed: Client does
not support authentication protocol requested by server. Consider
upgrading MySQL client at ./test.pl line 8

Can anyone tell me whether this new authentication method is supported
by DBD::mysql, and if yes, what I need to do to get it to work? Or if
it is going to be supported in the future? Or where I can locate the
source code, libraries, protocol specs, or whatever is needed to fix
this myself? I could not find the documentation of the MySQL
client/server authentication protocol anywhere.

Presumably many users don't have this problem because their client
will simply fall back to some older method, if it is still enabled.

Thanks, -- Peter

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org