MySQL Forums
Forum List  »  Backup

Re: Restore Not working for encoded passwords
Posted by: Felix Geerinckx
Date: December 19, 2005 03:32AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Restore Not working for encoded passwords
3015
December 19, 2005 03:32AM


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.