How i can delete User?
I have a question,i want deleted some spamers from my MediaWiki. I konw that i must go in the database and delete the user from there.
My question,where i must go exactly to delete the Users ? I see many tables,but not no who the rigt table.
Hope somebody can help me :-)
Sorry for my english,not my native language
Best Wishes, ~Comppro
I have the same problem like Seriana, How to merge 7900 Spam accounts? There must be a solution directly working on the database, it is unfeasable to do that over a WikiPage. Regards, Markus
If you want to do that in the database, the easy way is to go to the table "user" and to delete all the users, which you do no longer want. You can do that, but this is relational data. Meaning: MediaWiki does not only use it for the usernames, but also associates posts and other stuff with these table rows. If you just remove them without checking, if they are still used anywhere else, you will break your wiki.
A rather clean solution, which I found very usable, is Extension:User_Merge_and_Delete. It takes care for those references automatically. This drastically reduces the risk of screwing up your wiki.
I'm with the others on looking for a solution on how to delete several hundred spam accounts on my wiki. the User_Merge_and_Delete is simply not capable of tackling this in a method that is worthwhile or plausible. I would also greatly appreciate attempting to lock-out certain functions, or find a better User Registration to stop this spamming or at least diminish it.
-Keith (hoosierhackerhouse.com; a Shadowrun Gaming Wiki)
If these accounts are only there and never got used, you can use the maintenance script removeUnusedAccounts.php to remove these accounts. If you find better ways, let us know, however, others also were not successful as you can see from the missing feedback in this very thread. You can delete the user records from the DB directly; fast and simple. But don't complain when it breaks your wiki.
If you have a list of known good accounts, you can use Extension:BlockandNuke and Extension:UserMerge to merge spam accounts into the user Spammer. BlockandNuke will also ban the IP addresses from editing.
I've been using this on my personal spam-bait wiki and have blocked over 10,000 IP addresses in the last month.