On Mar 4, 2004, at 18:17, Dan Carlson wrote:
I've got a user who's forgotten his password
and needs to get it back.
Is there an easy way that I can reset the password field for him, or
find out the password and send it to him? I've tried looking in
phpMyAdmin, and all I see are the blob and tinyblob fields, and I
don't know how to interpret those.
On the login page there's a "mail me a new password" button. If they've
got an e-mail address set in their account, they should be able to put
in the username and hit this button and will receive a newly generated
password. (The existing password remains valid unless the user logs in
with the new one... the passwords are stored as a one-way hash so it's
not possible to recover the plaintext password, a new one has to be
generated.)
If they don't have an e-mail address configured, you can poke it into
the user_email field in the database. It's possible that the password
mailing won't work in all possible configurations, so you might want to
try it with a test account to make sure it's functional.
-- brion vibber (brion @
pobox.com)