Bug #2320 Incorrect SQL statement in Old Client appendix
Submitted: 8 Jan 2004 7:29 Modified: 8 Jan 2004 10:41
Reporter: Dean Ellis Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version: OS:
Assigned to: Bugs System CPU Architecture:Any
Triage: D4 (Minor)

[8 Jan 2004 7:29] Dean Ellis
A.2.4 Client does not support authentication protocol error

SELECT * FROM mysql.user WHERE LEN(password) > 16;

should be

SELECT * FROM mysql.user WHERE LENGTH(password) > 16;

How to repeat:

Suggested fix:
Change LEN to LENGTH.
[8 Jan 2004 10:41] Paul Dubois
Thank you for your bug report. This issue has been addressed in the
documentation. The updated documentation will appear on our website
shortly, and will be included in the next release of the relevant

Additional info:

Fixed.  Thanks!