Passwords don't work after DB import

Be careful with this one.

MySQL versions prior to 4.1 use a 16-byte hash to store PASSWORD() encrypted fields, whereas the newer versions use a 41-byte hash. This might be why you can't log in any more...

Export the passwords separately and re-encrypt at the other end.

Posted 06 Sep 2007, tagged with mysql