Hi there

I have MySql 4.1 up and running on my system now but when I try to access the database using a perl script I get the following error:

DBI connect('my_database:localhost','root',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at database_connection.pl line 9

The perl script in question is:

use DBI;

my $dsn = 'DBI:mysql:my_database:localhost';
my $db_user_name = 'root';
my $db_password = '<my root password>';
my ($id, $password);
my $dbh = DBI->connect($dsn, $db_user_name, $db_password);

I understand that mysql 4.1 changed its password authenication so I used the OLD-PASSWORD function in order to revert back to the old style, but although that worked, I still dont get rid of the error.

Any help would be much appreciated.

My system is a PC running SuSe 9.0

Ffenics

http://www.mysql.com/doc/en/Old_client.html