RE: :mysql
From: Henry McGuinness (henry_mcguinness_at_yahoo.co.uk)
Date: 10/12/04
- Next message: Henry McGuinness: "RE: :mysql"
- Previous message: Marco Avvisano: "Re: Fwd: DBD::Informix A configuration failure"
- In reply to: Elliot Fielstein: "RE: :mysql"
- Next in thread: Henry McGuinness: "RE: :mysql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Date: Tue, 12 Oct 2004 13:18:57 +0100 (BST) To: dbi-users@perl.org
Hi Elliot, thanks for replying,
--- Elliot.Fielstein@med.va.gov wrote:
> Henry,
>
> Have you tried any of these fixes?
>
> http://dev.mysql.com/doc/mysql/en/Old_client.html
will have a look, thanks.
>
> Are you sure you're running MySQL 4.1.5 because the
> 'upgrade client' error
> is typically caused by using a post 4.1.1 password
> scheme with a pre 4.1.1
> client.
Yes, it's definitely 4.1.5 running. I was wondering if
DBD-MySQL has caught up with the new password scheme!
Have now tried DBDs from ordinary repository and Randy
Kobes' site. (PPM3 appears to have older versions of
the DBD on it)
regards
Henry
>
> -----Original Message-----
> From: Henry McGuinness
> [mailto:henry_mcguinness@yahoo.co.uk]
> Sent: Monday, October 11, 2004 12:15 PM
> To: dbi-users@perl.org
> Subject: DBD::mysql
>
>
> 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
___________________________________________________________ALL-NEW Yahoo! Messenger - all new features - even more fun! http://uk.messenger.yahoo.com
- Next message: Henry McGuinness: "RE: :mysql"
- Previous message: Marco Avvisano: "Re: Fwd: DBD::Informix A configuration failure"
- In reply to: Elliot Fielstein: "RE: :mysql"
- Next in thread: Henry McGuinness: "RE: :mysql"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
Relevant Pages
|
