Re: Client does not support authentication protocol requested by server; consider upgrading MySQL client

[Jody Fedor]

I received the same error messages as everyone else:

Using Active State Perl version: ActivePerl 5.8.6.811
Using DBI version: 1.47
Using DBD-mysql version: 2.9003
Using MySQL version: MySQL 4.1.10-nt

Perl connect code:
my $dbh = DBI->connect ("DBI:mysql:database=$database:host=$host",
$user,
$password)
or die "Can't connect to database: $DBI::errstr\n";


I got the error message:
DBI connect('database=rawlogs:host=localhost','root',...) failed:
Client does not support authentication protocol requested by server; consider upgrading MySQL
client at rawtlogs.pl line 13
Can't connect to database: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Using the method:
UPDATE user SET password = old_password('your_password') WHERE user = 'your_user';
FLUSH PRIVILEGES;

I too was able to again access my database after upgrading from 4.0.17-nt!