Okay, I've now added this using the 'old-passwords' syntax in my.cnf file. Still doesn't make any difference.
Have no idea about how to change passwords from 'old' to 'new'???? -----Original Message----- From: Peter Burden [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 5:19 PM To: Paul DuBois Cc: Christensen, Dave; '[EMAIL PROTECTED]' Subject: Re: MySQL 4.1 and MyCC Paul DuBois wrote: > At 11:55 -0500 6/11/03, Christensen, Dave wrote: > >> I upgraded my test MySQL server yesterday to 4.1 and I'm now >> receiving an >> error when I try to connect using MyCC. The error is ERROR 1249: >> Client >> does not support authentification protocol requested by server. Consider >> upgrading MySQL client. I've tried to find a solution on the >> website, but >> either it's not mentioned there or my search skills need some refinement >> (probably the latter :-) >> >> Anyone have any idea what I have to do to solve this one? > > > Start the server with the --old-passwords option. > > Or put this in an option file: > > [mysqld] > old-passwords Thanks - that also answers an earlier post of mine - although I think it should be "old-password" and if you've (as I did) set up 4.1 with "new" style passwords, you can't then just drop this into /etc/my.cnf without also changing all the passwords - the new and old schemes encrypt in a different way AFAIK. > > > That'll force the server to use the older password authentication > mechanism. > >> >> David Christensen >> Brokers International, Ltd. >> 1200 E Main St >> PO Box 160 >> Panora, IA 50216 >> (800) 362-1097 or (641) 755-2775 >> [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> >> >> >> >> -- >> MySQL General Mailing List >> For list archives: http://lists.mysql.com/mysql >> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > -- >From Peter Burden, [EMAIL PROTECTED] http://www.scit.wlv.ac.uk/~jphb -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
