Re: Decrypting PASSWORD() from MySQL
| From: | Paul DuBois | Date: | Wed, 19 Dec 2001 20:27:30 +0000 |
| Subject: | Re: Decrypting PASSWORD() from MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15120@lists.php.net to get a copy of this message | ||
On Wed, Dec 19, 2001 at 12:24:02PM -0700, Zach Curtis wrote:
> I have a form for a user to request their forgotten username and password by
> entering their email address. I then process this and use mail() to send
> them their username and password. However, the password is stored in an
> encrypted PASSWORD('password') field in the MySQL table. How can I retrieve
> the decrypted password in a SELECT statement?
You can't. It's a one way encryption. It even says so in the MySQL
Reference manual entry for PASSWORD().