--- sivsenxml_3969 <[EMAIL PROTECTED]> wrote:

> I have a problem in encrypt and decrypt. I have created a database for
> user registration using mysql. In that i have get the password from
> the registration form and encrypt that using password() function in
> mysql and stored the value in database. Again i am retrieving the
> password from the database and i want to decrypt that.
> 
> Please send me the suggestions to solve this problem.
> 
> Thanks
> Nathan

The MySQL function password() is a one-way encryption.  There is not supposed
to be a way to return that value to the original clear-text password input. 
Instead, you would use the same function to process the user input and see if
the hashed values are the same.  In theory, no two inputs should generate the
same password hash.

There are functions for encrypting and decrypting values based on a key and you
may be looking for something like this:

http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html

James Keeline

Reply via email to