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]
