[thelist] md5 hashed password problem

[Bob Meetin - 303-926-0167 - www.dottedi.biz]

OLD SITE:  mysql> select password("bananas");
+-------------------------------------------+
| password("bananas")                       |
+-------------------------------------------+
| *9E303C97B1C59D393AFCCAEB156C148C1F9E0D67 |
+-------------------------------------------+
1 row in set (0.00 sec)

NEW SITE:  mysql> select password("bananas");
+-------------------------+
| password("bananas") |
+-------------------------+
| 0b0d276260c19cd1        |
+-------------------------+
 
Also on NEW:

mysql> show variables like '%pass%';
+-------------------------+
| old_passwords |  ON     |
+-------------------------+

Yes they are different.   

show variables like '%pass%'; retuns "OFF" on the old site (but newer mysql version) that I am transferring away from (running away from).  Sorry if I don't understand all the underlying stuff.

Hassan Schroeder wrote:
> On 8/15/07, Bob Meetin - 303-926-0167 - www.dottedi.biz
> <bobm at dottedi.biz> wrote:
>   
>> according to phpinfo() - client api version = 5.0.27 on the old site and
>> 4.1.21 on the new site (hostgator).  Bananas works...
>>