1
cschloeg
mySQL MD5 Question
  • 2004/3/3 18:04

  • cschloeg

  • Just popping in

  • Posts: 7

  • Since: 2004/1/13


Hey,

I've started using XOOPS recently and on a side note am lovin it. I've just imported my user info from my old CMS and it took some persuading but I got everything lined up. Now my problem is that my old system did not MD5 the passwords, they were stored in their unencrytped beauty. Is there a Query or any function that can encrypt my "pass" column so that my users can get on the site?

Peace,
Chris

2
Mithrandir
Re: mySQL MD5 Question

First: Backup the user table

Second: Try this one
"UPDATE xoops_users SET password=PASSWORD(password)"


Someone else please confirm this one. I'm not all that familiar with one-line SQL sentences which work on the database only and not with script variables

3
Dave_L
Re: mySQL MD5 Question
  • 2004/3/3 19:26

  • Dave_L

  • XOOPS is my life!

  • Posts: 2277

  • Since: 2003/11/7


That should be:

UPDATE xoops_users SET password=MD5(password)


As Mithrandir said, make you backup the users table first, in case this doesn't do what you want.

4
cschloeg
Re: mySQL MD5 Question
  • 2004/3/3 20:09

  • cschloeg

  • Just popping in

  • Posts: 7

  • Since: 2004/1/13


Perfect, thanks for the help guys.

Login

Who's Online

169 user(s) are online (99 user(s) are browsing Support Forums)


Members: 0


Guests: 169


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Nov 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits