How do I delete all non-confirmed users in MediaWiki

I had an issue that bots/spammers have created hundreds of users on our mediawiki page.

They are not harmful, since a user needs to be confirmed before it can edit, and neither have been.

I have now installed a captcha to stop that - http://www.mediawiki.org/wiki/Extension:ConfirmEdit

How can I clean this huge list of users? *it spans over more than a day

Solution 1:

You can try using the following extension called UserMerge: http://www.mediawiki.org/wiki/Extension:UserMerge

With UserMerge can merge the offending accounts into one and then delete the remaining account. I don't know if UserMerge will allow you to merge en mass; if not it may not be an ideal solution.

You can also use Nuke to mass delete pages created by an offending account: http://www.mediawiki.org/wiki/Extension:Nuke

Also a similar post on StackOverflow gives instructions on how to use SQL to neutralize an account: https://stackoverflow.com/questions/10706451/mediawiki-mass-user-delete-merge-block

Best of luck! I have had the same problem on my Mediawiki install.