Hello,

What I know, MySQL changed in 4.1 the password mechanism, so is it possible, 
thar you need knew passwords in our DB.
I have these Problem in some application, which makes pass check over MySQL :-(

By Alex  

> -----Urspr�ngliche Nachricht-----
> Von: Burak G�rsoy [mailto:[EMAIL PROTECTED] 
> Gesendet: Donnerstag, 4. November 2004 13:37
> An: perl-DBI
> Betreff: mysql 4.1x and DBD::mysql (and mysqlPP)
> 
> I saw a discussion about that on the list, but I've recently 
> upgraded to 4.1.7-nt for testing and now I can't connect to 
> the server from perl. I remember someone suggested 
> re-compiling DBD::mysql from source against new libraries, 
> but DBD::mysqlPP also can not connect to the server (also I'm 
> not very familiar with linking/compiling process). So, are 
> there any other suggestions? 
> 
> [Perl: Active Perl 5.8.4 build 810;
> OS: Windows XP Professional/SP2
> DBD::mysql installed via ppm]
> 
> Test code:
> 
> #!/usr/bin/perl -w
> use strict;
> use DBI;
> 
> my $driver   = "mysql";
> my $database = "burak";
> my $user     = "root";
> my $pass     = "";
> 
> print "DBI is $DBI::VERSION\n\n";
> test();
> $driver = "mysqlPP";
> test();
> 
> sub test {
>    my $drv = "DBD::$driver";
>    print "[Testing $drv]\n";
>    eval {
>       my $DSN = sprintf "DBI:%s:database=%s", $driver, $database;
>       my $dbh = DBI->connect($DSN,$user,$pass,{RaiseError => 
> 1,AutoCommit => 1});
>          $dbh->disconnect;
>    };
>    print $@ if $@;
>    printf "$drv version: %s\n\n", $drv->VERSION; }
> 
> __END__
> 
> Output:
> 
> DBI is 1.45
> 
> [Testing DBD::mysql]
> DBI connect('database=burak','root',...) failed: Client does 
> not support authentication protocol requested by server; 
> consider upgrading MySQL client at C:\Documents and 
> Settings\Burak\Desktop\test.pl line 20 DBD::mysql version: 2.9004
> 
> [Testing DBD::mysqlPP]
> DBI connect('database=burak','root',...) failed: Couldn't connect to
> /tmp/mysql.sock:  at C:/Perl/site/lib/DBD/mysqlPP.pm line 109 
>  at C:\Documents and Settings\Burak\Desktop\test.pl line 20
>       (in cleanup) Can't call method "close" on an undefined 
> value at C:/Perl/site/lib/DBD/mysqlPP.pm line 314.
> DBD::mysqlPP version: 0.04
> 
> 
> 
> 
> 

Reply via email to