Re: Decrypting PASSWORD() from MySQL

> 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. This is what I do: 1) Use password('$password') to store my passwords. 2) Since this is a one-way algoritme I replace the password with some random letters (and encrypt it!) 3) Then I email the new password to the user 4) And.. force the user to change the password at the first login. Best Regards Fredrik A. Takle Bergen, Norway