Tried this and it didn't make any difference. Still getting the error when I try to connect to the server with MyCC. I CAN connect using the command line mysql program.
-----Original Message----- From: Paul DuBois [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 11, 2003 5:08 PM To: Peter Burden Cc: Christensen, Dave; '[EMAIL PROTECTED]' Subject: Re: MySQL 4.1 and MyCC At 23:18 +0100 6/11/03, Peter Burden wrote: >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. Actually, the option *is* "--old-passwords" (with an "s"), though probably the option processor will recognize both. Also, if you have set up 4.1 accounts with new passwords, you can still connect to those accounts, even with --old-passwords, but only when using 4.1 clients. > >> >> >>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]> -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
