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:
None 
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 
Description:
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:

[QUOTE]
PASSWORD(str)

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'
[/QUOTE]

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

How to repeat:
n/a

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!