connecting to mysql in remote

[xnavigator]

Hello,

in my pc I have php&mysql v4 and I am trying to connect to my server that has mysql v5..

But mysql_connect says:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

What should I do?

thanks!

[Receptional Andy]

What are you using to connect to the remote database? Is this a program or script of some kind?

[rocknbil]

Client does not support authentication protocol requested by server; consider upgrading MySQL client

This is a well documented problem I've encountered many times. It has to do with converting the old password algorithm to the new one. Simplest fix,

mysql> SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('newpwd'); 

Documentation [dev.mysql.com]

[xnavigator]

thanks! I have created new user and I have launched the query with old_password...

now the user works both on php4 and php5 ;)