[thelist] md5 hashed password problem

[Rick den Haan]

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 ;-)

HTH,
Rick.

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