Shell Programming and Scripting

Dear Friends,

I am tryin to connect to the myql through perl scrip. I have already installed mysql and DBI modules to my Perl.

There versions are as follows,

DBD-mysql [2.1026] MySQL driver for the Perl5 Database
DBI [1.34] Database independent interface for

It gives erroe when I tried to connected to the sql. The error as follows,

Mysql connect('database=pps_cdr;host=localhost','root',...) failed: Client does not support authentication protocol requested by server; consider upgrading MySQL client at db_test.pl line 7

My perl script as follows,

use Mysql;
my $DBHOST = "localhost";
my $DBNAME = "pps_cdr";
my $DBUSER = "root";
my $DBPASS = "mahesh";

$DB = Mysql->connect($DBHOST, $DBNAME, $DBUSER, $DBPASS);

Can somebody tell me how can I avoid this error.

Thanks,
Mahesh Fernando

Try this, i'm running number of perl scripts with mysql, i never had any problems...


use DBI;

#Specify the MySQL server
my $host = "localhost";

my $username = "root";
my $password = "mahesh";

my $db_name = "pps_cdr";

my $dsn = "DBI:mysql:database=$db_name;host=$host";

$dbh = DBI->connect($dsn, $username, $password);

$self->dbh = $dbh;


I have learned mysql perl programming by searching google, you can also find lot of stuff in google...

One possibility: the pre-4.1 client and 4.1+ server problem. In MySQL 4.1 the format of authentication token has changed to use garbled passwords of greater length (and thus greater cryptographic strength). MySQL clients 3.x/4.0 only support the old, shorter password hash, then authentication will fail with 4.1+ servers. If your server is 4.1 or later, it is quite likely this is the problem.

Your DBD::mysql is a compiled Perl module which requires a MySQL client library on compilation. That client version shall become the version of the client used by the DBD::mysql module. Try to reinstall your DBD::mysql to use a newer client library and see if that works.

Another way to get around this: enable the "old_passwords" option at the server, reinitialize *ALL* passwords at the server then the passwords should now be stored in old, shorter format (you should check the mysql.user table to make sure).

And I have forgotten. Don't use the Mysql module. Use DBI with DBD::mysql instead, as you said you have installed it in your previous post. Mysql and DBD::mysql are two separate modules. DBD::mysql supersedes Mysql.

Hi Guys,

Thanks for the help.
After updating my perl module it is working fine.

Thaks,
mahesh