Re: Error In Using Perl To Connect To MySQL

Sherm Pendley <sherm@xxxxxxxxxxx> wrote:

Louis <t051315@xxxxxxxxxxx> writes:

Sherm Pendley wrote:
Louis <t051315@xxxxxxxxxxx> writes:

OS: Windows XP SP2
Perl version : v5.8.7 built for MSWin32-x86-multi-thread
MySQL version : server: 5.0.21-community-nt
MySQL version : client: 5.0.11

Both Perl and MySQL work on my machine. I wanted to test using Perl
to manipulate MySQL data.

I installed DBI and DBD:mysql. And when I try testing to connect to
MySQL inside a perl script, I got the following error:

DBI connect('database=mymusic;host=localhost','root',...) failed:
Client does not support authentication protocol requested by server;
consider upgrading MySQL client at mydbi.pl line 24
No need to upgrade, just give 'root' an old-style password. Have a
look:
<http://dev.mysql.com/doc/refman/5.1/en/old-client.html>
sherm--

Hi Sherm,

Thank you for your solution. It works. I am still puzzled by the
explanation though. I have never used MySQL pre 4.1. Whatever works.

Are you using ActiveState Perl? If so, and if you're using DBD::mysql
from a PPM, then that's using whatever MySQL client library version that
ActiveState built it against. That could very well be a pre-4.1 version.

Yup, Sherm is right, it has to do with how the library talks with MySQL.
If you are going to use MySQL with other programs, like PHP, you might
bump into this issue more often. I am already considering to downgrade to
the MySQL 4.x branch since there might be other issues as well (for
example the handling of defaults IIRC).

--
John Bokma Freelance software developer
&
Experienced Perl programmer: http://castleamber.com/
.

Relevant Pages

  • Re: Perl DBD-My with SQL 5.0
    ... > upgrading MySQL at client. ... This has nothing to do with Perl, btw - any client app that uses the MySQL ...
    (comp.lang.perl.misc)
  • Re: execute failed: Lost connection to MySQL server during query(2013)
    ... It might be that DBD::mysql on your system is built with a MySQL client ... > Windows 2000 and perl version is 5.8.3. ... > Lost connection to MySQL server during query error 2013 recorded: ...
    (perl.dbi.users)
  • Re: DELETING records using MYSQL Database
    ... you don't have the rights for a local infile operation for that mysql ... ask the Perl Guys to run the infile op as a perl script with your file - ... mySql / VFP / MS-SQL ... > remote table - DELETE FROM, I want to repopulate it with data from ...
    (microsoft.public.fox.vfp.queries-sql)
  • script help to update member profiles
    ... form is all stored in a MySql Database (First Name, Last Name, Username, ... my partner that did all the perl scripts was injured ... Compare entered username and password to database to confirm the user is ...
    (comp.lang.perl.misc)
  • DBI / DBD / MySQL installation problem
    ... I used to run Red Hat 9, and had a perfect relationship with Perl, DBI, ... able to connect to MySQL from Perl via DBI. ... Running install for module Mysql ...
    (perl.dbi.users)