sherzodR writes:
>
> Hmm, I can't aggree with having two password columns, one raw password and
> another is encrypted. It just doesn't make any sence. Why do you need to
> encrypt the password in that case, don't you still have the original
> password in yoru database? It just defeats the whole
;
mussat: > To: Zach Curtis <[EMAIL PROTECTED]>
mussat: > Cc: [EMAIL PROTECTED]
mussat: > Subject: Re: Decrypting PASSWORD() from MySQL
mussat: >
mussat: > Zach Curtis writes:
mussat: > > I have a form for a user to request their forgotten username and
passwo
On Wed, 19 Dec 2001, Matt Wagner wrote:
> Date: Wed, 19 Dec 2001 13:51:30 -0600 (CST)
> From: Matt Wagner <[EMAIL PROTECTED]>
> To: Zach Curtis <[EMAIL PROTECTED]>
> Cc: [EMAIL PROTECTED]
> Subject: Re: Decrypting PASSWORD() from MySQL
>
> Zach Curtis writes
/decipher
Thanks,
Zach
-Original Message-
From: Matt Wagner [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 19, 2001 12:52 PM
To: Zach Curtis
Cc: [EMAIL PROTECTED]
Subject: Re: Decrypting PASSWORD() from MySQL
Zach Curtis writes:
> I have a form for a user to request their forgot
Zach Curtis writes:
> I have a form for a user to request their forgotten username and password by
> entering their email address. I then process this using PHP and use mail()
> to send them their username and password. However, the password is stored in
> an encrypted PASSWORD('password') field i
zach: How can I retrieve the decrypted password in a SELECT statement?
You can't!
If you want them to deal with forgotten passwords, here is a standard way:
Whenever they submit their email addresses to retrieve their passwords,
just generate a random password, and send it to the user's emai
- Original Message -
From: "Zach Curtis" <[EMAIL PROTECTED]>
> an encrypted PASSWORD('password') field in the MySQL table. How can I
> retrieve the decrypted password in a SELECT statement?
MySQL's password() function is a one way hash. It does not have a
decryption function. Regardless
