Skip to content

Instantly share code, notes, and snippets.

@brianyoungblood

brianyoungblood/sanitize_drupal_users.sql

Created October 24, 2012 21:27
Show Gist options
  • Save brianyoungblood/3949011 to your computer and use it in GitHub Desktop.
Save brianyoungblood/3949011 to your computer and use it in GitHub Desktop.
Download ZIP
sanitize drupal users
Raw
sanitize_drupal_users.sql
UPDATE users SET pass = md5('mypasswordchanged2012') WHERE uid > 1;
UPDATE users SET mail = concat('myaddr+', replace(mail, '@', '_'), '@testdomain.org') WHERE uid <> 0 AND instr(mail, '@testdomain.org') = 0;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment