Bulk Delete Users
I had 1000 spammer registrations from the same 2 domains.
Here’s how I got rid of them all, in seconds..
From the PLESK database “Web Admin”:
Delete the users..
delete FROM wp_users
WHERE user_email LIKE ‘%@domain.com’
** you could use ANY criteria here – I wanted rid of two specific groups of spammers..
Now-> Delete Orphaned Usermeta
** BACKUP YOUR DATABASE FIRST!
NB: you COULD try the “Bulk Delete Users” Plugin, but it tries to delete them one-by-one. On my shared hosting, it times out and is effectively useless, which is why I’m using SQL at the backend.
Please note: You should NEVER leave your tables with the default “wp_” prefix. Or have a user called “admin”, or a user with id=1. That’s just for start!
Let us secure your WordPress site for you:
http://www.q292u.com/services/secure-your-wordpress-site-our-new-fiverr-gig