March 28th, 2000, 12:14 AM
I use the PASSWORD function to encrypt the password provided by the users in a registration form in my site.
The problem is that the password is encrypted and stored. I am not able to decrypt it whenever I require it.With use of Password func how do I decrypt it?
Thanks in advance
March 28th, 2000, 06:31 AM
There is no complement to the password() function for decrypting.
March 28th, 2000, 07:07 AM
Instead of decrypting password,
you can encrypt another password by
using PASSWORD() .
ex) select PASSWORD('another_one');
Or, check the rows what is correct.
ex) select id from MEMBER_TABLE where password = PASSWORD('another_one');
August 17th, 2000, 04:27 PM
Hi Paxjesus and others.
I'm a newbie to mysql, php and so on, but I'm getting the basic idea, BUT..
is it then tru if the simpel line:
Encrypts the "another_one" string?
how can this be?
August 17th, 2000, 06:59 PM
password() is just a built in function of mysql that uses a propriety system to encrypt the string passed. No magic to it.