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