Balakrishnan K wrote:
> I am using mysql 4.1.7 server. In my database i have a table for username and password. In this
> table the username is a varchar field and password is password field. I use to store the password by
> using the encode function. And it works well while retrieve the password using decode function.
>
> But when the backup sql script (taken by mysqldump utility) is executed, it also executes .
> But i can't retrive my password using decode function.Yes the password is changed and becomes
> unpredictable.
Have you followed the advice from
http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html:
ENCODE(str,pass_str)
Encrypt str using pass_str as the password. To decrypt the result, use DECODE().
The result is a binary string of the same length as str. If you want to save it in a column, use a BLOB column type.
--
felix
Please use
BBCode to format your messages in this forum.