Trouble connecting from mysql 4.1 to 5.0
 

Hi all!

Im having trouble to connect from my server to mysql 5.0 server.
Everything works fine in shell (mysql -h blabla.com -u bla -p)
But when my perl script tries to access that same database i get this error message:

Cannot connect to db server: Client does not support authentication protocol requested by server; consider upgrading MySQL client

I got this same error message in shell also but it went away when i updated mysql to 4.1.

-------------------------
My server:

Your MySQL connection id is 30 to server version: 4.1.11-Debian_4sarge1-log


--------------------------
Other server:

Your MySQL connection id is 1210 to server version: 5.0.9-beta-nt

--------------------------


Any help would be appreciated


-Happy

You probably use a kind of perl module to access the server. It probably needs to be updated (just like the shell client).