[thelist] md5 hashed password problem

Anthony Baratta anthony at baratta.com
Wed Aug 15 12:27:22 CDT 2007


I found this while poking around. Since you need to "replciate" the new password functionality on a mySQL box that is using the olde password function, you'll have to roll your own password hashing routine.

"PASSWORD() is just a double SHA-1 hash"
"in both PHP and MySQL native there are direct SH1() functions"

http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html

http://us3.php.net/sha1

Hope this helps.




More information about the thelist mailing list