Anonomize Non-Public WordPress User Data

If you need to remove non-public user data from a WordPress database, these SQL queries should do the trick for you:

View the code on Gist.

Note that if you have plugins, etc. that store additional user data in user meta you might need to clear those out as well.