DBI connect failure

I am getting this error and I have never seen it before :

DBI connect('test','mysql',...) failed: Client does not support
authentication protocol requested by server; consider upgrading MySQL
client at ./b.pl line 109
Unable to connect to DB: Client does not support authentication protocol
requested by server; consider upgrading MySQL client

It says to upgrade MySQL client, but I am already running 4.1.1.

This is what I have installed:

perl-DBD-MySQL-2.1021-3
MySQL-server-4.1.1-1
MySQL-devel-4.1.1-0
MySQL-client-4.1.1-0

And this is how I am connecting:


use DBI;

my $dsn = 'DBI:mysql:Viper';

# connect to DB
my $Dbh = DBI->connect( $dsn, 'mysql', 'mysql' ) or die "Cant connect to
DB: $DBI::errstr";

Any input would be much appreciated.

Thank you.




--
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

Re: DBI connect failure

On Wed, 17 Dec 2003, Mayuran Yogarajah wrote:

> I am getting this error and I have never seen it before :
>
> DBI connect('test','mysql',...) failed: Client does not support
> authentication protocol requested by server; consider upgrading MySQL
> client at ./b.pl line 109
> Unable to connect to DB: Client does not support authentication protocol
> requested by server; consider upgrading MySQL client
>
> It says to upgrade MySQL client, but I am already running 4.1.1.

You have to relink DBD::mysql against the newer client libraries.


Rudy


--
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

Re: DBI connect failure

On Wed, 17 Dec 2003, Mayuran Yogarajah wrote:

> I am getting this error and I have never seen it before :
>
> DBI connect('test','mysql',...) failed: Client does not support
> authentication protocol requested by server; consider upgrading MySQL
> client at ./b.pl line 109
> Unable to connect to DB: Client does not support authentication protocol
> requested by server; consider upgrading MySQL client
>
> It says to upgrade MySQL client, but I am already running 4.1.1.

You have to relink DBD::mysql against the newer client libraries.


Rudy


--
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