Re: PASSWORD in mysql 4.1.x

[Harrison Fisk]

Hi,

You don't. The password() function changed to be a more secure hasing algorithm. The details are at http://dev.mysql.com/doc/mysql/en/password-hashing.html

You should generally use one of the well defined functions such as MD5() or SHA1() for application use. http://dev.mysql.com/doc/mysql/en/encryption-functions.html says the same thing under the password() function.

Harrison Fisk, Trainer and Consultant
MySQL AB, www.mysql.com