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! 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' )") ; ?> 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
Archived
This topic is now archived and is closed to further replies.