How to anonymise user names and emails?

Question

The developer stages need their user names and email address anonymised. I did not find anything googling the subject matter. Maybe somebody developed a Drush extension for this? Any other suggestions are welcome too.

Answer 1

You can use drush sql-sync command to sync the database and obscure email addresses and the user passwords during db deployment.

--sanitize Obscure email addresses and reset passwords in the user table post-sync.

Check drush help sql-sync for help.

Answer 2

I came up with this:

drush sql-query "
  UPDATE users 
  SET 
    name=CONCAT('User-',uid),
    mail=CONCAT(uid,'@anon.com'), 
    init=CONCAT(uid,'[email protected]') 
  WHERE uid > 0;"
drush upwd User-1 --password=SecureAdminPassword

Answer 3

You need, drush sql-sanitize

$ drush sql-sanitize -h
Run sanitization operations on the current database. You can add more sanitization to this command by implementing hook_drush_sql_sync_sanitize().

Examples:
 drush sql-sanitize                        Sanitize database without modifying any passwords.
 --sanitize-password=no
 drush sql-sanitize                        Sanitizes database but exempts two user fields from modification.
 --whitelist-fields=field_biography,field
 _phone_number

Options:
 --db-prefix                               Enable replacement of braces in sanitize queries.
 --db-url                                  A Drupal 6 style database URL. E.g., mysql://root:[email protected]/db
 --sanitize-email                          The pattern for test email addresses in the sanitization operation, or "no" to keep email addresses unchanged. May contain replacement patterns %uid, %mail or %name. Example value: user+%uid@localhost
 --sanitize-password                       The password to assign to all accounts in the sanitization operation, or "no" to keep passwords unchanged. Example value: password
 --whitelist-fields                        A comma delimited list of fields exempt from sanitization.

Aliases: sqlsan