[thelist] md5 hashed password problem

Brady Mitchell mydarb at gmail.com
Wed Aug 15 10:34:15 CDT 2007


> OLD SITE:
> 
> mysql> select password("bananas");
> 
> NEW SITE:
> 
> mysql> select old_password("bananas");

You're comparing apples to oranges here. You need to run the same query 
on both servers and compare the results. password() and old_password() 
work differently, so the results you posted are expected.

Run select password("bananas"); on both systems and compare that output.

Using old_password() is only helpful/necessary if you've upgraded from 
mysql < 4.1 to something > 4.1.

Brady



More information about the thelist mailing list