can't logon to db with mysql client: mysql 5 passwords

I recently have had some difficulty getting my mysql client to logon to my
remote dbs and I'm thinking it may be that my host service has shifted to
mysql 5.x from 4.x. I know there is a password validation difference.
Can anyone clarify and suggest a remedy.

On 2006-04-28, rog <jk!ttop5@mnpX$.net> wrote:
> I recently have had some difficulty getting my mysql client to logon
> to my remote dbs and I'm thinking it may be that my host service has
> shifted to mysql 5.x from 4.x. I know there is a password validation
> difference. Can anyone clarify and suggest a remedy.

If you're getting a 'Client does not support authentication protocol
requested by server; consider upgrading MySQL client' message, then your
suspicion is indeed right, see:
http://dev.mysql.com/doc/refman/5.0/en/old-client.html

--
Riemer Palstra Amsterdam, The Netherlands
riemer@palstra.com http://www.palstra.com/

Thanks, that's what I was looking for...



"Riemer Palstra" <riemer@palstra.com> wrote in message
news:slrne546mn.lsg.riemer@palstra.com...
> On 2006-04-28, rog <jk!ttop5@mnpX$.net> wrote:
>> I recently have had some difficulty getting my mysql client to logon
>> to my remote dbs and I'm thinking it may be that my host service has
>> shifted to mysql 5.x from 4.x. I know there is a password validation
>> difference. Can anyone clarify and suggest a remedy.
>
> If you're getting a 'Client does not support authentication protocol
> requested by server; consider upgrading MySQL client' message, then your
> suspicion is indeed right, see:
> http://dev.mysql.com/doc/refman/5.0/en/old-client.html
>
> --
> Riemer Palstra Amsterdam, The Netherlands
> riemer@palstra.com http://www.palstra.com/