Skip to content

Embed URL


Subversion checkout URL

You can clone with
Download ZIP
Remove non-public user data from standard WP database.
-- generic email addresses and new passwords for users
UPDATE wp_users
SET user_email = CONCAT(user_login, ''),
user_pass = MD5(CONCAT(RAND(), CAST(ID AS CHAR), user_login));
-- generic email addresses for commentors
UPDATE wp_comments
SET comment_author_email = CONCAT(CAST(comment_ID AS CHAR), '');
-- admin email address
UPDATE wp_options
SET option_value = ''
WHERE option_name = 'admin_email';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Something went wrong with that request. Please try again.