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]
