ENCODE() on MySQL 5.0 differs from 5.5+
Posted by: Carl Dreher
Date: November 12, 2012 10:18AM

I was running MySQL 5.0 on Windows XP and using the ENCODE() and DECODE() functions to encode passwords in the database. I've moved to version 5.5 which is now running under Windows 7 64-bit.

I've discovered that the ENCODE/DECODE functions provide a different result in the new version. I've verified this by comparing the value produced by ENCODE for a known password on the 5.0 system, to the value produced for the same password on the 5.5 system. (Both systems use the same encoding string, of course.)

Any explanations? This caused a big headache for user passwords, none of which now work on the new system. Fixing the new database is straightforward, of course, but what I'm really interested in is what happened.

Options: ReplyQuote

Written By
ENCODE() on MySQL 5.0 differs from 5.5+
November 12, 2012 10:18AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.