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
|