MySQL Bugs: #8185: Client does not support authentication protocol requested by server

Bug #8185	Client does not support authentication protocol requested by server
Submitted:	28 Jan 2005 18:35	Modified:	29 Jan 2005 20:28
Reporter:	Nasir Ahmed	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / ODBC	Severity:	S1 (Critical)
Version:	mysql odbc 3.51	OS:	Windows (WINDOWS XP SR2)
Assigned to:	Dean Ellis	CPU Architecture:	Any

Description:
HI, I've installed MySQL sever on my Windows XP Pro srv pk 2.  It is working fine.  Now, I am trying to connect throurgh ODBC and testing from the same PC and having the following error:

Client does not support authentication protocol requested by server; consider upgrading MySQL client

How to repeat:
Go to XP control panel> Administrative Toolset> ODBC administration
Then setup ODBC Data Source Administer to use MySQL ODBC driver and necessary info, user, password, etc
Press Test Data Sources and I get the above error.

You need to use a version of MyODBC (3.51.10 or newer, with 3.51.11 to be released soon) which is linked to the MySQL 4.1 client, or you must disable the use of the new password scheme in the MySQL 4.1 server:

http://dev.mysql.com/doc/mysql/en/old-client.html