[thelist] md5 hashed password problem

Rick den Haan rick.denhaan at gmail.com
Wed Aug 15 09:34:45 CDT 2007

Bob Meetin wrote:
> select * from members where login='some_member' AND 
> password=PASSWORD('entered_password')

It's possible that the servers you moved between use different MySQL
versions. After version 4.1 the PASSWORD() function was modified[1]. If your
new host uses an older MySQL version, that might be the culprit.

A quick search didn't offer a way to decrypt the password hash (other than
creating a database of all possible string/hash combinations, but that will
take a while ;-)


[1]: http://dev.mysql.com/doc/refman/5.0/en/password-hashing.html

More information about the thelist mailing list