How to delete 17000 users

  • Resolved developingaheadache

    (@developingaheadache)


    3 years, 11 months ago

    I had this setup to allow users to create their own account. Roughly 17000 bogus accounts resulted. I see that as an admin I can delete the accounts one page at a time but there are 890 pages of accounts and it seems I cannot select all subscribers, only one page worth of subscribers at a time.

Viewing 2 replies - 1 through 2 (of 2 total)
  • Plugin Author Marcus (aka @msykes)

    (@netweblogic)

    The best way would be via the DB I think, you could do it via SQL in wp_users and then clean up the wp_usermeta with something like:

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

    This is something unrelated to our plugin specifically though since you would need to install a captcha or similar to prevent that kind of thing for WP in general. There’s a few out there compatible with LWA as well. In your case, the spammers chose to submit via our form rather than the wp-login.php form.

    Thread Starter developingaheadache

    (@developingaheadache)

    Yep. I ended up doing the deletion in the wp_users table database and cleaned up the wp_usermeta. Henceforth users are only created by the administrator

Viewing 2 replies - 1 through 2 (of 2 total)
  • The topic ‘How to delete 17000 users’ is closed to new replies.