Unix Technical Forum

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

This is a discussion on can't logon to db with mysql client: mysql 5 passwords within the MySQL forums, part of the Database Server Software category; --> I recently have had some difficulty getting my mysql client to logon to my remote dbs and I'm thinking ...


Go Back   Unix Technical Forum > Database Server Software > MySQL

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 02-28-2008, 07:38 AM
rog
 
Posts: n/a
Default 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.


Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 02-28-2008, 07:38 AM
Riemer Palstra
 
Posts: n/a
Default Re: can't logon to db with mysql client: mysql 5 passwords

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/
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 02-28-2008, 07:39 AM
rog
 
Posts: n/a
Default Re: can't logon to db with mysql client: mysql 5 passwords

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/



Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 07:22 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com