Web Admin – q292u

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

Byq292u

Delete, Gig, Sql Delete, Web Admin

WordPress Database – Delete Orphaned Usermeta

Delete Orphaned Usermeta..

After using SQL to bulk-delete users, you’ll be left with (potentially a lot) of orphaned records in the “usermeta” table. You don’t want that. It’ll just waste space and clog things up.
After deleting 1000 user records, I had 20000 orphaned usermeta records – you get the picture..

From PLESK web admin, or similar:

delete FROM wp_usermeta WHERE user_id NOT IN (
SELECT ID
FROM wp_users
);

** BACK UP YOUR DATABASE FIRST!

Tag Archive Web Admin