Same username+password as live but login with it locally.

[leitel]

I am staging for an upgrade from 4.1x to 4.2.2.
I pull down db+code, run upgrade, go to login as admin and it rejects credentials.
I compare live/local password+salt for userid=1 and they are the same.

I run the following using the ACTUAL admin password:

UPDATE `user`
SET `password` = MD5(CONCAT(MD5('****'), `user`.`salt`))
WHERE `userid` = 1;

I can now login. HOWEVER, I compare previous/updated password values and they are DIFFERENT!!!!

Is the updated codebase using a different hashing method being used?

What's going on?

Thank You