pixeltrace Posted June 12, 2007 Share Posted June 12, 2007 hi, i accidentally loaded a csv file and forgot to set the password fields to md5 what is the sql query that will change my password to md5? like UPDATE users SET password =md(password) WHERE password='123456'"; hope you could help me with this. thanks! Quote Link to comment https://forums.phpfreaks.com/topic/55199-how-to-change-password-to-md5/ Share on other sites More sharing options...
Caesar Posted June 12, 2007 Share Posted June 12, 2007 From phpmyadmin or whatever SQL command prompt/application you are using... UPDATE `table` SET `password` = md5( 'password' ) ; From PHP... <?php $db->query("UPDATE table SET password = md5( 'password' )") ; ?> Quote Link to comment https://forums.phpfreaks.com/topic/55199-how-to-change-password-to-md5/#findComment-272883 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.