Change Members Password In Bulk

Hello

How do you change the password of user in bulk. 
Please advise. Thanks. 

You might need a php script to loop members and change their pass. Might take some time depends on resources. How many members you have?

Each person to get the same password? or each person to get a different password read from a file? It is to cover all of members in the database or just a few?

Because how to do it or what procedures would be followed would depend on precisely what needs to be done.

Coming up with a solution to a problem requires that the problem be adequately explained in detail.

 Hello

You mentioned this in a previous forum post but how do you change many ids in one sql query?

UPDATE `Profiles` SET `Salt` = CONV(FLOOR(RAND()*99999999999999), 10, 36) WHERE `ID`='1';

UPDATE `Profiles` SET `Password` = SHA1(CONCAT(md5('New Admin Password'), `Salt`)) WHERE `ID`='1';

I hit report by accident. They really need to move that button. It's to close to the quote button. Anyhow.



You can replace the WHERE `ID`='1'; at the end with something like this.


WHERE `ID`='1' AND `ID`=2 AND `ID`=3 AND `ID`=4 AND `ID`=5 AND `ID`=6 AND `ID`=7 AND `ID`=8 AND `ID`=9 AND `ID`=10

Or if you want to change ALL passwords just leave the WHERE `ID`='1'; off and it will do all of them.


As i mentioned in my previous post. BULK can mean a lot of things and what you need to do will would depend on precisely what needs to be done.

 Suggestion!

Maybe this would be better

WHERE `ID` IN('1', '2', '3', '4',........);

 Thanks Deano and Prashank25

 Yup you can. But IN has a limit. But there is also a limit to the length of a query, so i guess it makes no difference.