Authentication protocol error connecting with perl

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

Re: Authentication protocol error connecting with perl

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

There's also a 100% Perl-licensed connector that supports both old and
new authentication:
http://search.cpan.org/~dubex/Net-Wire10-1.06/lib/Net/Wire10 .pm

(It is a simpler beast than DBD-MySQL and so may not be useful in
every situation..)

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=gcdmp-msql-mysql-modules@m .gmane.org

Re: Authentication protocol error connecting with perl

--000e0cd4a75c4db1750482c0e1a4
Content-Type: text/plain; charset=ISO-8859-1

Thanks,

I appreciate your thought. However, I was able to install the Winnipeg
module, and I'm doing o.k. with DBI.

Also, I'm working on a multi-user system, and I'm going to have to lock the
tables.

Cheers,

Hugh



On Sat, Mar 27, 2010 at 3:21 AM, wrote:

> > 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.
>
> There's also a 100% Perl-licensed connector that supports both old and
> new authentication:
> http://search.cpan.org/~dubex/Net-Wire10-1.06/lib/Net/Wire10 .pm
>
> (It is a simpler beast than DBD-MySQL and so may not be useful in
> every situation..)
>
> --
> MySQL Perl Mailing List
> For list archives: http://lists.mysql.com/perl
> To unsubscribe: http://lists.mysql.com/perl?unsub=hugh@loebner.net
>
>

--000e0cd4a75c4db1750482c0e1a4--

Re: Authentication protocol error connecting with perl

> I appreciate your thought. =A0However, I was able to install the Winnipeg
> module, and I'm doing o.k. with DBI.

Might be useful to someone else :-).

Net::Wire10 does have a DBI component by the way, it's called DBD::Wire10.

> Also, I'm working on a multi-user system, and I'm going to have to lock t=
he tables.

Hm?

--
MySQL Perl Mailing List
For list archives: http://lists.mysql.com/perl
To unsubscribe: http://lists.mysql.com/perl?unsub=3Dgcdmp-msql-mysql-modules @m.gmane.org