Accessing Mysql 5.0 from 4.0 server

"Trevor Price" <[email protected]>
Newsgroups gmane.comp.db.mysql.perl
Message-ID <[email protected]>
All,

On redhat es 3.0 taroon update 2

RPMS

MySQL-shared-compat-5.0.4-0
MySQL-server-4.0.21-0
MySQL-client-5.0.4-0
php-mysql-4.3.2-11.1.ent
MySQL-Max-4.0.21-0
MySQL-devel-4.0.21-0

Along with

Perl DBI 1.41
Perl DBD 2.9007

When I try to connect to a 5.0 server with perl I get

DBI connect(...) failed: Client does not support authentication protocol
requested by server; consider upgrading MySQL client at ./test_db.pl
line 7

Which is strange because my mysql client can connect to the 5.0 server.
I reinstalled DBD after upgrading the client and shared-compat rpms.
Any ideas?

Thanks,

Trevor

Trevor Price   | Production Operations Manager
DemandTec, Inc.  | 1 Circle Star Way, Suite 200 | San Carlos, CA 94070
tel | +1.650.226.4805   fax | +1.650.556.1190       
www.demandtec.com



<html>
<body>
  <span style="font-size:8.0pt;font-family:Arial">---------------------------------------------------------------------------------------------------------------------------------------------</span>
  <span style="font-size:8.0pt;font-family:Arial">DEMANDTEC EMAIL NOTICE:</span>
  <p><span style="font-size:8.0pt;font-family:Arial">NOTICE: This email transmission and all attached files contain information intended for the designated individual or entity to whom it is addressed and may contain information that is proprietary, privileged and/or exempt from disclosure under applicable law.  If you are not the intended recipient or an employee or agent responsible for delivering this message to the intended recipient, you are hereby notified that any dissemination, distribution, copying,  or other use of this email or its attachments is strictly prohibited.  If you have received this email in error, please notify the sender immediately by replying to this message and please delete the original message without making any copies.</span>
  <p><span style="font-size:8.0pt;font-family:Arial">WARNING: Computer viruses can be transmitted via email.  The recipient should check this email and any attachments for the presence of viruses.  Although we have taken reasonable precautions to ensure that this email and all attachments are free from viruses, we accept no liability for any loss or damage arising from the use of this email or its attachments.</span>
</body>
</html>
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.