Authentication protocol error connecting with perl

Hugh Loebner <[email protected]> Fri, 22 Jan 2010 09:59:51 -0500
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
--001636458ec0808627047dc21326
Content-Type: text/plain; charset=ISO-8859-1

Hello all,

I'm a newbie to MySQL, although I have some experience with Perl.  I have a
business system which works ok with BerkeleyDB.  Now I'd like to migrate to
MySQL.  All my db stores, fetches, are in subroutines, so I just have to get
the basic op's working.  This is a LAN based system, nothing using the web.

I have a Windows XP LAN with static IP's.

I have Perl ActiveState 5.8.9   I am using Emerald Editor as my dev. tool.

I installed MySQL on two computer "client" and  "MYSQLSV" with no apparent
problem.

I created a user "hugh" on "client" with all privileges (I think - status
says so)..

I have no problem using command prompt to have "hugh" on "client" connect to
MySQL on MYSQLSV,  and insert a row in table "menx".

However, when I try to connect using Perl I get the message:
---------
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

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

Thanks for any help.

--001636458ec0808627047dc21326--