ST Alpha - "usually you would UPDATE usertable SET password = md5( 'passwordstring' ) WHERE id = userID" (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Login
Create Account

Search Dr. S. Talk
TT/ST Wiki
How Well Do You Know ...

RSS Feed

Hosting by DigitalOcean

Support ST on Ko-Fi

Down to Post

Backboards:

Posts: 151

In response to "Database admins/web encryption gurus: I've been placed in charge of a website. I'm trying to reset this one user's password from the database side. " by Dr.Vermin

Favourites: 1

usually you would UPDATE usertable SET password = md5( 'passwordstring' ) WHERE id = userID

Posted by Beryllium (aka grayman) Jan 20 '11, 14:34

But it could also be sha1.

Responses:

Goddamn, I love you man. - Dr.Vermin Jan 20, 14:38 3
- just ... never forget the WHERE clause, or every user in the entire database will have their password reset to the new one. - Beryllium Jan 20, 14:43 2
  - Awesome. Again, thanks. - Dr.Vermin Jan 20, 14:47 1
    - oh, yeah ... you can also do the md5 thing when editing the fields (in the drop-down menu to the left of the input box) -- nm - Beryllium Jan 20, 14:49

Post a message top

Replies are disabled on threads older than 7 days.