AW: Authentication protocol error connecting with perl

Hugh,

> -----Urspr=FCngliche Nachricht-----
> Von: Hugh Loebner [mailto:[email protected]]=20
> Gesendet: Freitag, 22. Januar 2010 16:00
> ---------
> use DBI;
> $dsn =3D "DBI:mysql:database=3Dmenx;host=3Dmysqlsv";
> $dbh =3D DBI->connect($dsn, 'hugh', 'password');
> ---------
> "C:\Perl\bin\perl.exe" mysqltest.pl
> DBI   connect('database=3Dmenx;host=3Dmysqlsv','hugh',...)=20
> failed: Client does
> not support authentication
> protocol requested by server; consider upgrading  MySQL=20
> client at mysqltest.pl line 3
Which version of MySQL (the server programme) are you running? (Use the =
MySQL cmd line client, run the query=20
select version();
Which version of DBD::MySQL are you running? (Run, from the command =
line,
perl -MDBD::mysql -e "print $DBD::mysql::VERSION"

Background: There was a change in the authentication protocol that the =
MySQL server uses by default. That happened years back, But if you're =
using an old DBD::mysql, it might not know about it yet.

For more details, cf. =
http://dev.mysql.com/doc/refman/5.1/en/old-client.html

>=20
> > Terminated with exit code 0.
> >
> It also fails in the same way when I try to connect using=20
> user "root" which should have every privilege.
No, nothing to do with the user and his privileges. The problem arises =
before MySQL can even start to check the privileges in detail.
=20

-- 
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe:    http://lists.mysql.com/[email protected]