http://www.mysql.com/doc/M/i/Miscellaneous_functions.html
Using the PASSWORD function is an irreversible process. Check the above link. A work around is you always deal with the encrypted password on the server side. E.g. When the user will login you encrypt the submitted password and do a SELECT with the resulting String. Regards, Al > -----Original Message----- > From: Manish Mehta [mailto:[EMAIL PROTECTED]] > Sent: Monday, March 04, 2002 2:12 PM > To: mysql > Subject: encrypt password > > > Hi , > > I am working in mysql . with the help of password() function I insert the > data in some table . > > for example :- > > insert into a values (password('name')); > > when I fire select query . It shows me this -> 23e6065b74 > > I wants to decrypt the data again in same format as I insert with Select > query. > > please tells me the process . > > Thx in advance > > Manish Mehta > > > > --------------------------------------------------------------------- > Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
