MySQL's password () function and MD5 function

Password is used to modify the MySQL user password, if it is applied with the Web program recommend using the MD5 () function, Password function Legacy 16-bit, new version 41-bit, can be viewed with select length (Password (' 123456 ')). Password function encryption is not reversible, if compared with the database in the encrypted content can be used password (pwd) = = field content mode; MD5 function encryption After 32 bits, this encryption algorithm is not reversible, in fact, the MD5 algorithm is an information digest algorithm, if the compression is also lossy compression, theoretically even if there is a reverse algorithm can not restore information as it is. He is often used to verify the integrity of downloaded data. If a lot of software provide MD5 code, for users to download complete verification integrity.

From:http://hi.baidu.com/phay/blog/item/b77c3f29a66e2afe99250a9b.html

MySQL's password () function and MD5 function