Are you about to get a freelancer to work on your existing WordPress site for you or one of your clients?
Here’s a simple SQL script you can run against your dev database to randomise all the user information EXCEPT a test login before you send it over to them. It will also set that test login’s password to ‘password’.
/*************************************************************
MAKE A FULL BACKUP OF YOUR DATABASE BEFORE RUNNING THIS SCRIPT
**************************************************************/
/** Test login is wp_users.ID = 383 */
SET @SIFT_ID=xxx;
/** Set the password to 'password' */
UPDATE wp_users SET user_pass='$P$BdpHKeNPW6usjHE/nwSE.nG1Y5Couw0' WHERE ID=@SIFT_ID;
/** obfuscate user table data */
UPDATE wp_users SET
/** email address format */
user_email = CONCAT(SUBSTRING(MD5(RAND()), -10), "@", SUBSTRING(MD5(RAND()), -10), ".com"),
/** random strings */
user_pass = CONCAT("pass_", SUBSTRING(MD5(RAND()), -10)),
user_nicename = CONCAT("nice_", SUBSTRING(MD5(RAND()), -10)),
user_login = CONCAT("login_", SUBSTRING(MD5(RAND()), -10)),
display_name = CONCAT("display_", SUBSTRING(MD5(RAND()), -10))
/** except our test login */
WHERE ID != @SIFT_ID;
UPDATE wp_usermeta SET
/** random strings */
meta_value = SUBSTRING(MD5(RAND()), -10)
WHERE (user_id != @SIFT_ID AND (meta_key='last_name' OR meta_key='first_name' OR meta_key='nickname'));
All you need to do is get a value for the test user’s ID and replace xxx in `@SIFT_ID=xxx` with it above.
There are a couple of simple ways to figure out the ID for your test user:
SQL
For the user with username login_022b366d32
`SELECT ID, user_login FROM wp_users WHERE user_login=’login_022b366d32′;`
The ID field is the one you want.
URL
Go to the user’s screen in wp-admin and mouse over ‘capabilities’, you should see the user_id value in your status bar:
