Bug #6855 Client does not support authentication protocol
Submitted: 27 Nov 2004 16:10 Modified: 16 Dec 2004 20:33
Reporter: Jon Stephens Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S2 (Serious)
Version:4.1.7 OS:Windows (Windows 2000)
Assigned to: Bugs System CPU Architecture:Any

[27 Nov 2004 16:10] Jon Stephens
Description:
mysqlc cannot be used to log in with the new (4.1.1+) authentication protocol.

How to repeat:
Try to log in using mysqlc with a user/password created in the normal fashion.

Result: "ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client"

Now try using mysqlc to log in with a password set with the OLD_PASSWORD() function.

Result: Able to log in.

Suggested fix:
1. Fix mysqlc so it uses updated authentication.

or

2. Remove mysqlc from the win32 builds and documentation.
[27 Nov 2004 22:59] MySQL Verification Team
Thank you for the bug report. Indeed the mysqlc is an older binary
linked with an older client library for to support readline capabilities
on Win9x and not necessary for Windows 2000.
[16 Dec 2004 20:33] Matt Wagner
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

Fixed in 4.1.8. We have decided to drop mysqlc.exe from the distribution.
[18 Dec 2004 2:21] Jon Stephens
Can somebody make sure that this is dropped from the 5.0.x series as well, if this hasn't already been done? Thanks.