Re: Error while connecting to data base.

[Patrick Galbraith]

mohammed.mustafa@stripped wrote:

>Hi Patrick,
> 
>   I am using the same version like 5.8.6 which I downloaded from
>cpan.org.
>Thanks for your kind attention.
>  
>
Mohammed,

What I mean is the database server  - what version of MySQL are you using ?

If you do:

mysql -u mohammed -p mohammed -h 10.207.36.119 uitest

then:

mysql>select version();

What do you get?

Also do this:

perl -e 'use DBI; print "$DBI::VERSION\n"'

perl -e 'use DBD::mysql; print "$DBD::mysql::VERSION\n"'

Also:

locate libmysqlclient

Thanks,

Patrick

>Thanks,
>Mustafa
>
>
>-----Original Message-----
>From: Patrick Galbraith [mailto:patg@stripped] 
>Sent: Thursday, May 08, 2008 7:12 PM
>To: Mohammed Mustafa (WT01 - Testing Services)
>Cc: perl@stripped
>Subject: Re: Error while connecting to data base.
>
>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