Ben, create a column in the user table, that holds a flag called "mustChangePassword" (or whatever you want to name it). Then write your PHP code that way, that a login of a user who must change his password will be redirected to the "change password page" and store the new password and reset the flag to false.
Regards Hans -----Ursprüngliche Nachricht----- Von: Ben C. [mailto:benc@;cox.net] Gesendet: Mittwoch, 13. November 2002 18:27 An: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Betreff: Re: Decrypt MYSQL Password I am a little new to MySQL and PHP. How do I make the password a temporary password. So when they login the first time they need to reset the password? Thanks for you help in advance. Ben > > From: "Merlin, The Mage" <[EMAIL PROTECTED]> > Date: 2002/11/13 Wed AM 04:20:20 EST > To: "Ben C." <[EMAIL PROTECTED]> > CC: [EMAIL PROTECTED] > Subject: Re: Decrypt MYSQL Password > > -----BEGIN PGP SIGNED MESSAGE----- > Hash: SHA1 > > Hi Ben, > > From the MySQL man online @ > http://www.mysql.com/doc/en/Miscellaneous_functions.html#IDX1330 : > > PASSWORD() encryption is non-reversible. > > To create a forgot your password page, the best method is to generate a net > password and send that new password. To make it easier to your users to > remember their passwords, the best way is to set that password as a temporary > one, that only allows them to set the original password. (maybe using a > diferent field, so they can keep the original password if someone else goes > to your site and request the password, just because he was bored. > > MPNeves > > On Wednesday 13 November 2002 07:27 am, Ben C. wrote: > > I am using the MySQL password() function for the my passwords on the user > > names. How do I decrypt the password in PHP to send it in an e-mail. I am > > making a forgot your password page and want to have the user enter their > > e-mail and have the password sent to them. > > > > Please help! > > > - -- > Merlin, the Mage > themage.camelot.co.pt > -----BEGIN PGP SIGNATURE----- > Version: GnuPG v1.0.6 (GNU/Linux) > Comment: For info see http://www.gnupg.org > > iD8DBQE90hleKOMrqDFTeBARAoc7AKDozVXEVP8Tfv8Qjx9DE4ChPF8zsACaAh/C > efo5W0z4+dO3UEvTnDz9qJk= > =i4Oj > -----END PGP SIGNATURE----- > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php