Re: Error while connecting to data base.

[Patrick Galbraith]

Mohammed,

What version of MySQL are you running?

regards,

Patrick

mohammed.mustafa@stripped wrote:

>Hi,
>
>  I am new to perl and database and trying to connect to the data base,
>but getting the below error.
>
>And perl version I am using is 5.8.5.
>
> 
>
>[wipcafe@testbrix Test]$ perl data.pl
>
>DBI connect('database=mustafa;host=10.207.36.108','root',...) failed:
>Client does not support authentication protocol requested by server;
>consider upgrading MySQL client at data.pl line 7
>
>can't connect: Client does not support authentication protocol requested
>by server; consider upgrading MySQL client at data.pl line 7.
>
> 
>
>And please find the code here........
>
> 
>
> use DBI;
>
> 
>
>  # $user = "mohammed";
>
>  # $pass = "mohammed";
>
>  #my $dbh = DBI->connect
>("dbi:mysql:uitest;host=10.207.36.119",$user,$pass) or
>
>  my $dbh =
>DBI->connect("DBI:mysql:database=mustafa;host=10.207.36.108","root",
>"wipcafe")or
>
>                          die "can't connect: $DBI::errstr";
>
> # my $dbh =
>DBI->connect("DBI:mysql:database=uitest;host=10.207.36.119",$user,$pass)
>or
>
> #  my $dbh =
>DBI->connect("DBI:mysql:database=uitest;host=localhost",$user,$pass) or
>
>#    die "can't connect: $DBI::errstr";
>
>  $dbh->do ("DROP all");
>
>  $dbh->disconnect ();
>
> 
>
>end DBI;
>
> 
>
>Please guide me for that error.  I am very new to perl and data base, so
>even basic things will be welcome.
>
> 
>
>While installing DBI, only I able to install DBI and not other two
>modules Data::ShowTable & DBD::mysql
>
>And the error while installing is as below.
>
> 
>
>The module Data::ShowTable isn't available on CPAN.
>
> 
>
>Thanks,
>
>Mustafa
>
> 
>
>
>Please do not print this email unless it is absolutely necessary. 
>
>The information contained in this electronic message and any attachments to this
> message are intended for the exclusive use of the addressee(s) and may contain
> proprietary, confidential or privileged information. If you are not the intended
> recipient, you should not disseminate, distribute or copy this e-mail. Please notify the
> sender immediately and destroy all copies of this message and any attachments. 
>
>WARNING: Computer viruses can be transmitted via email. The recipient should check
> this email and any attachments for the presence of viruses. The company accepts no
> liability for any damage caused by any virus transmitted by this email. 
>
>www.wipro.com
>
>  
>


-- 
Patrick Galbraith, Senior Programmer 
Grazr - Easy feed grazing and sharing
http://www.grazr.com 

Satyam Eva Jayate - Truth Alone Triumphs
Mundaka Upanishad