כיצד להסיר מידע אישי ממסד הנתונים שלך לצורך תמיכה

-- replace the user email and user information with a scrambled one
UPDATE wp_users SET user_login = CONCAT('test', ID), user_nicename = user_login, user_email = CONCAT('email+test', ID, '@example.com'), user_url = '', display_name = user_login;

-- replace user first name and last name with scrambled information 
UPDATE wp_usermeta SET meta_value = CONCAT('test', user_id) WHERE meta_key IN ('first_name', 'last_name', 'nickname');

-- replace users passwords with a simpler one
UPDATE `wp_users` SET `user_pass`=MD5('testing') WHERE 1;

-- replace admin email with a scrambled one
UPDATE wp_options SET option_value = 'email+test@example.com' WHERE option_name = 'admin_email';