Re: Authentication protocol error connecting with perl

--001485f3bdb82eca6e047e00b324
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Hi,

The problem is using MySQL with ActiveState's DBD-MySQL ver 2.x).  AS's
DBD-MySQL is out of date (I was told there was a licensing problem with Sun
Co).  The solution is to use the winnipeg repository and get version 4.x of
DBD-MySQL.

Things worked fine after that.

Hugh



On Sun, Jan 24, 2010 at 8:34 PM, Selke, Gisbert W. <
[email protected]> wrote:

> Hugh,
>
> > -----Urspr=FCngliche Nachricht-----
> > Von: Hugh Loebner [mailto:[email protected]]
> > 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',...)
> > failed: Client does
> > not support authentication
> > protocol requested by server; consider upgrading  MySQL
> > 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
> 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 usi=
ng
> 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
>
> >
> > > Terminated with exit code 0.
> > >
> > It also fails in the same way when I try to connect using
> > 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.
>
>

--001485f3bdb82eca6e047e00b324--