Error In Using Perl To Connect To MySQL

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

My problems:
1) I installed MySQL. I couldn't find separate server and client installations. So I am not sure how to "upgrade client".

Appreciate for any help. Thank you.
.

Relevant Pages

  • Re: Some free utilities for Java, with Hebrew support.
    ... mostly separate from the one for replacing the client library. ... Then you're a MySQL reseller, by the sounds of it, rather than a MySQL ... I.e. they might use MySQL server and client, ... competing libraries, so I'd expect to see it happen sooner or later. ...
    (comp.lang.java.programmer)
  • 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: Confusion about database updates
    ... all connecting to the same database server. ... MySQL can easily handle many simultaneous clients. ... AlphaCluster all open multiple connections to a MySQL server running on ... Let the MySQL server do that when your client ...
    (comp.lang.java.databases)
  • Re: commands out of sync problem
    ... server and client application like this: ... Add a SQLconnection for the MySQL database ... and...tada 'commands out of sync: you can't run this command now'. ...
    (alt.comp.lang.borland-delphi)