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. <
Gisbert.Selke@stripped> wrote:
> Hugh,
>
> > -----Ursprüngliche Nachricht-----
> > Von: Hugh Loebner [mailto:hugh@stripped]
> > Gesendet: Freitag, 22. Januar 2010 16:00
> > ---------
> > use DBI;
> > $dsn = "DBI:mysql:database=menx;host=mysqlsv";
> > $dbh = DBI->connect($dsn, 'hugh', 'password');
> > ---------
> > "C:\Perl\bin\perl.exe" mysqltest.pl
> > DBI connect('database=menx;host=mysqlsv','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 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
>
> >
> > > 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.
>
>
