Epidemic Posted November 15, 2008 Share Posted November 15, 2008 Hey, I have got an old username and password database for my users of my websites. However when I first made my website I didn't know about MD5 encryption, but I now do. However I want to MD5 all of there passwords in my members table. Is there any SQL query I can use to MD5 all the passwords in the passwords collum? I really do hope there is because otherwise I have 200 + passwords to MD5. Josh Quote Link to comment https://forums.phpfreaks.com/topic/132840-solved-md5-a-whole-column/ Share on other sites More sharing options...
dropfaith Posted November 15, 2008 Share Posted November 15, 2008 not that i ever recall learning but you could use a php script to pull them all out at once md5 and resubmit them to the db i think at least hrmm Quote Link to comment https://forums.phpfreaks.com/topic/132840-solved-md5-a-whole-column/#findComment-690862 Share on other sites More sharing options...
Mchl Posted November 15, 2008 Share Posted November 15, 2008 UPDATE users SET password = MD5(password); But before you do it. Did you think about salting your passwords? Quote Link to comment https://forums.phpfreaks.com/topic/132840-solved-md5-a-whole-column/#findComment-690869 Share on other sites More sharing options...
Epidemic Posted November 15, 2008 Author Share Posted November 15, 2008 No, what is salting? Quote Link to comment https://forums.phpfreaks.com/topic/132840-solved-md5-a-whole-column/#findComment-690889 Share on other sites More sharing options...
Mchl Posted November 15, 2008 Share Posted November 15, 2008 Salt is basically a string of random character you add to each password, so that decrypting it was more difficult. (See Wikipedia article for more) Quote Link to comment https://forums.phpfreaks.com/topic/132840-solved-md5-a-whole-column/#findComment-690903 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.