Hi folks,
This seems to be a DBI issue. I've just reinstalled
most things so I'm running:
Activestate Perl 5.8.4
MySQL 4.1.5 ("gamma" but it should be ok surely?)
DBI 1.43
DBD::MySQL 2.9004
running on Windows XP professional.
Tried to do a simple select (works fine from MYSQL in
command prompt - users have the right privileges).
>From a perl script or from Apache I get the following
message:
"Client does not support authentication protocol
requested by server; consider upgrading MySQL client"
Relevant code:
use DBI;
my $dbh =
DBI->connect("dbi:mysql:namesDB;host=localhost",".....",".....")
or die "Can't make 1st database connect:
$DBI::errstr\n";
my $sth1 = $dbh->prepare("SELECT name, address FROM
tbl_people WHERE (Txtname = ?)");
$sth1->execute("Dave");
while (@res=$sth1->fetchrow_array) {
print "@res[0] : @res[3]: @res[4]\n\n" ;
}
$sth1->finish();
$dbh->disconnect();
(Have also tried without the "host=localhost" part of
the connect statement)
Anyone seen this/know what's going on?
thanks
Henry
___________________________________________________________ALL-NEW Yahoo! Messenger -
all new features - even more fun! http://uk.messenger.yahoo.com
