How To Delete All WordPress Spam Comments Using phpMyAdmin

I have website that attacker more than 2000 spam each days. And I am so unhappy with it. I know I haven’t installed any Comment Preventing system.  The WordPress spam comment attack is pretty smart because it is definitely automated and all the IP address were different. I assume the WordPress comment spamming tool uses a list of open proxy and tries to post comments in every article.

Deleted Spam Comment using phpMyAdmin

So I will so you another ways how to easy deleted all WordPress un approved and spam comment using phpMyAdmin easily.

First you need download and install phpMyAdmin and configure it, if you are using cPanel hosting. You didn’t need it. So go to next step.

Second, login to your phpMyAdmin and select your databases where your blog install it. And go to your SQL Query menu and executed this SQL Query

delete from en_comments where comment_approved = 'spam'

This code will quickly remove all comment that have status spam. If you want remove only spam that not yet approved use this SQL Query

delete from en_comments where comment_approved = '0'

That’s it, now you Spam and moderation comment has been clearly on your WordPress. If you have a lot of spam again and need the quickest way, do this SQL Query again.

Photos taken from http://www.flickr.com/photos/dasqfamily/1556719729/