Kuopassa.net

Lisää kirjoituksia netistä.

Etsi blogista

Removing spam user accounts from WordPress en masse

Written

One approach to deleting spammy user accounts from WordPress is to launch phpMyAdmin or something similar. If the website in question isn’t really a multi user site, it should be easy to collect actual/real user accounts and export them from database. Then the database table could be truncated and previously exported data could then be imported.

Idea: removing by suspicious email address

DELETE FROM `wp_users` WHERE `user_email` LIKE '%@yahoo.com%';

This code example removes from a database table wp_users those rows that have a matching part @yahoo.com in the field where email address is stored.

Idea: removing by incremental number (ID)

DELETE FROM `wp_users` WHERE `ID` > 5 AND `ID` < 5000;

The code above will attempt to remove rows from wp_users table where the field ID has larger value than 5 and smaller than 5000.

About the author

"Removing spam user accounts from WordPress en masse" is rated 7 out of 10. That rating was formed of 1 vote(s). Kuopassa.net´s blog includes a total of 1183 posts including this one. If you´d like to link to this page from a blog or a forum, please use this permalink. Tag or tags: .

Tsekkaa myös minkälaisia valokuvia teen: www.pjti.fi