Thanks for your suggestions.

Nathan

James Keeline <[EMAIL PROTECTED]> wrote:                               --- 
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
 
 
     
                               

       
---------------------------------
Never miss a thing.   Make Yahoo your homepage.

[Non-text portions of this message have been removed]

Reply via email to