ST Alpha - "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. " (Reading a Post)

SlickerTalk
Search Archives
The Leaderboard
The FAQ

Down to Post

Backboards:

Posts: 151

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.

Posted by Dr.Vermin (aka Dr.Vermin) Jan 20 '11, 14:34

But when I look at the password field on this dude's record, it's like "ee9d030adee2a5dfe02e8f2482adf6ba".

So, i'm guessing it gets encrypted (this may be the wrong word) at some point.

Just typing in a password and hitting update doesn't seem to work. Must I translate the new password to be into this longer value before inserting into the database? If so, how?

TIA.

Responses:

usually you would UPDATE usertable SET password = md5( 'passwordstring' ) WHERE id = userID - Beryllium Jan 20, 14:34 4 1
- 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

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.

Replies are disabled on threads older than 7 days.