Notifications
Clear all

Limited Support

Our support team is currently on holiday from December 25, 2025 to January 7, 2026, and replies may be delayed during this period.

We appreciate your patience and understanding while our team is away. Thank you for being part of the wpForo community!

Merry Christmas and Happy Holidays! 🎄

How do I delete 32,000 inactive users (UI can do only handful at a time)?

2 Posts
2 Users
1 Reactions
815 Views
Posts: 127
Topic starter
(@mplusplus)
Reputable Member
Joined: 6 years ago

Hi there,

My WPForo has over 32,000 inactive users (bot attack) and I need to delete them all. (Admin UI allows only a handful at a time, so I need a better way). 

Is there a MariaDB SQL Query that I can run or do something else to delete all inactive users in one go? I have attached the list of table names in my database.

Thanks.

 

PS: I found some SQL queries but they did not work for my case.


1 Reply
Sofy
Posts: 5637
 Sofy
Admin
(@sofy)
Support Team
Joined: 8 years ago

Hi,

You can use the code provided here: https://wpforo.com/community/how-to-and-troubleshooting-2/delete-inactive-users/#post-77189.

Just change the prefix according to your website.


Reply