MySQL Forums
Forum List  »  Backup

Restore Not working for encoded passwords
Posted by: Balakrishnan K
Date: December 15, 2005 11:10PM

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.

Though there are 1000s of usernames and passwords , it causes very big problem.

So kindly tell me the way of dumbing or executing the script.

Thank you.

Options: ReplyQuote

Written By
Restore Not working for encoded passwords
December 15, 2005 11:10PM

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.