Member Avatar for Shuel

Hi,

If anyone can help me with this would be very mych appreciated.

My problem is I have a database full of users that has been built up over the years. The password field in the db is not been encrypted and the password is visible to all. I would like to know if there is a way I can write a code or there is a program that will take all the records in the database and encryot the password in say md5 encryotion and store them back in the password column.

Mnay thanks
Shuel

  • 3 Contributors
  • 2 Replies
  • 99 Views
  • 6 Hours Discussion Span
  • Latest Post Latest Post by pritaeas
Member Avatar for debasisdas

You simply need to apply the algorithm on the desired data.

Member Avatar for pritaeas

Just add another column to your table and run an UPDATE query.

UPDATE userstable SET newcolumn = MD5(passwordcolumn)

After the conversion is successful and your code has changed to use the new column, just remove the old column.

Edited by pritaeas because: n/a
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.