password

[jaytux]

what is the best way of storing passwords in a MySql database?
Is it ok (safe) to have them as plain text?
or is there a more advanced way to store passwords?
I have used the mysql password function to store password but this is only one way. i would like to be able to retrieve lost passwords.

Any ideas

[stolzyboy]

go to www.mysql.com and search for md5(), password(), encrypt(), etc....

http://www.mysql.com/doc/en/Miscellaneous_functions.html