How to bulk delete all WordPress subscribers?

Question

How to bulk delete all WordPress subscribers?

Vinnie James

2019年10月25日 08:54

I have 20,000 fake subscribers I'd like to get rid of. The admin panel only lets you delete 200 at a time.

How can I bulk delete all Wordpress subscribers via MySQL?

Topic mysql spam Wordpress

Category Web

Punitkumar Patel · Accepted Answer · 2017年4月22日 19:48

1

Punitkumar Patel answered at 2017年4月22日 19:48

You can use :

<?php
$blogusers = get_users( 'role=subscriber' );
// Array of WP_User objects.
foreach ( $blogusers as $user ) {
    $user_id = $user->ID;
    wp_delete_user( $user_id );
}

Vinnie James · Accepted Answer · 2017年4月22日 19:42

I ended up deleting all users who had not made a post using the following two queries:

First:

DELETE FROM wp_users
WHERE ID NOT IN (SELECT post_author FROM wp_posts)

Second:

DELETE
FROM wp_usermeta WHERE user_id NOT IN
(SELECT ID FROM wp_users)

How to bulk delete all WordPress subscribers?

About