AW: mysql 4.1x and DBD::mysql (and mysqlPP)

• Previous message: Blake Mitchell: "Re: faied tests installing DBD::ODBC on FreeBSD"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

Date: Fri, 12 Nov 2004 12:22:51 +0100
To: <dbi-users@perl.org>

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:burakgursoy@gmx.net]
> 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
>
>
>
>
>

• Previous message: Blake Mitchell: "Re: faied tests installing DBD::ODBC on FreeBSD"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]