Tag Archive Spammer

Byq292u

WordPress Database – Bulk Delete Users

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