Bug #15007 Tiny documentation error in Reference Manual
Submitted: 17 Nov 2005 8:19 Modified: 18 Nov 2005 15:12
Reporter: Felix Geerinckx (Basic Quality Contributor) Email Updates:
Status: Closed Impact on me:
Category:MySQL Server: Documentation Severity:S3 (Non-critical)
Version:5.0 OS:n/a
Assigned to: Stefan Hinz CPU Architecture:Any
Triage: D4 (Minor)

[17 Nov 2005 8:19] Felix Geerinckx
There is a tiny  mistake in http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html under the PASSWORD(str) entry.

It reads:


Calculates and returns a password string from the plaintext password str, or NULL if the argument was NULL. This is the function that is used for encrypting MySQL passwords for storage in the Password column of the user grant table.

mysql> SELECT PASSWORD('badpwd');
        -> '7f84554057dd964b'

The output is that of the pre-4.1 PASSWORD() function 

How to repeat:

Suggested fix:
Replace relevant part with:

mysql> SELECT PASSWORD('badpwd');
        -> '*AAB3E285149C0135D51A520E1940DD3263DC008C';
[17 Nov 2005 17:49] Valeriy Kravchuk
Thank you for a problem report.
[18 Nov 2005 15:12] Stefan Hinz
Fixed. Thanks!