Cleanup / Obfuscate Drupal Users (sets default password for all users to 'test')

user-scrub.sql

UPDATE users
SET name = CONCAT('user', (select @rownum:=@rownum+1 rownum FROM (SELECT @rownum:=0) r))
WHERE uid > 1;

UPDATE users
SET mail = CONCAT('user', (select @rownum:=@rownum+1 rownum FROM (SELECT @rownum:=0) r), '@example.com')
WHERE uid > 1;

UPDATE users
SET pass = '$S$DR.ROS3sDma71iTWcofZszOb8dMqrPi3PUWWNNc3rIwcG4ikL2gS'
where uid > 1;