Re: Error In Using Perl To Connect To MySQL

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.

Thank you very much.
.

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)