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
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 in the MySQL table. How can I
