[prev in list] [next in list] [prev in thread] [next in thread] 

List:       perl-win32-users
Subject:    Re: A problem with DBD-MySQL
From:       Randy Kobes <randy () theoryx5 ! uwinnipeg ! ca>
Date:       2005-02-28 5:40:12
Message-ID: Pine.LNX.4.56.0502272336170.4267 () theoryx5 ! uwinnipeg ! ca
[Download RAW message or body]

On Sun, 27 Feb 2005, George wrote:

> I've create a database in MySQL and try to access it this way from a
> script
> -- test.pl --
> #!/usr/bin/perl
> use strict;
> sub main ()
> {
>   use DBI();
>   # Connect to the database.
>   my $dbh = DBI->connect("DBI:mysql:database=cer;host=localhost",
>                          "cer", "cerpass",
>                          {'RaiseError' => 1});
>   # Disconnect from the database.
>   $dbh->disconnect();
> }
> main ();
> -- EOF --
>
> But I get the error:
> DBI connect('database=cer;host=localhost','cer',...) failed:
> Client does not support authentication protocol requested by server;
> consider upgrading MySQL client at Crete_Database.pl line 7
>
> How can I fix it?
>
> I use MySQL 4.1 from
> ftp://ftp.citkit.ru/pub/MySQL/Downloads/MySQL-4.1/mysql-essential-4.1.10-win32.msi
> I use Perl 5.8.6 from
> http://downloads.activestate.com/ActivePerl/Windows/5.8/ActivePerl-5.8.6.811-MSWin32-x86-122208.msi
> I installed DBI 1.47 and DBD-MySQL 2.9003 from
> http://ppm.ActiveState.com/PPMPackages/5.8-windows/MSWin32-x86-multi-thread-5.8/DBD-mysql-2.9003.tar.gz
> http://ppm.ActiveState.com/PPMPackages/5.8-windows/MSWin32-x86-multi-thread-5.8/DBI-1.47.tar.gz
> I use Win XP eng SP1

I've put up a DBD-mysql ppm package built against
mysql-4.1.10 at
   http://theoryx5.uwinnipeg.ca/ppms/
for ActivePerl builds 8xx, and
   http://theoryx5.uwinnipeg.ca/ppmpackages/
for 6xx. Does that work?

-- 
best regards,
randy kobes
_______________________________________________
Perl-Win32-Users mailing list
Perl-Win32-Users@listserv.ActiveState.com
To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
[prev in list] [next in list] [prev in thread] [next in thread]