Dilema:- MySQL Password function() and Recover lost password
Posted: Sun Jun 15, 2003 3:51 am
Hello folks,
I have a dilema. I am creating a site for my community with User Authentication. Now the passwords get saved into the database using mysql's password function. here is an example of my code
This enters the encrypted password in the database, but then I have another page(script) where members can recover their lost password and sent to them via email, but the script sends them the encrypted password. Its kinda useless that way to use mysql's built in password() function.
Can anyone give me a hint or a workaround, besides using MD5 and so on.
I have a dilema. I am creating a site for my community with User Authentication. Now the passwords get saved into the database using mysql's password function. here is an example of my code
Code: Select all
INSERT INTO TABLE_USER (username, password) VALUES (%s, password(%s))Can anyone give me a hint or a workaround, besides using MD5 and so on.