Mohsin Rasool - IAM & IGA Consultant

  • Home
  • About
  • Testimonials
  • Genesis Framework for WordPress – What, Why & How
  • Contact

Powered by Genesis

How to Delete All Those Spam Comments

September 26, 2009 by Mohsin Rasool

This is very risky to leave your WordPress blog open for all comment spam without adding any anti comment spam plugins.

This was the case with the blog which a client of us have, it had about 4000 spam comments, and it was going to take ages to delete them all from WordPress dashboard. So they came to us for the help.

We deleted all those about 4000 spam comment using little query operation at database level from phpmyadmin. I want to share the same process with you.

1. You need to login to your hosting panel and access PhpMyAdmin to access your database for that blog.

2. When you are there, select your blog’s database and then click SQL tab and run the following query:

DELETE FROM wp_comments WHERE comment_approved = 0

3. Wow within milliseconds all spam comment junk is gone.

Deleted rows: 3994 (Query took 0.1472 sec)

Now go to your wordpress blog and see all pending(spam) comments are gone. Now you please add some anti spam plugins to stop this thing happening again. I recommend you activate built-in plugin for comment spam called akismet. And add any other anti spam plugin you may like.

Filed Under: Internet Business, Productivity, Technology Tagged With: Comment Spam, delete spam, spam, Wordpress Plugins, Wordpress Tips

Recent Posts

  • Launch Again if Needed
  • Testing Gutenberg Editor
  • My Favorite Quotes
  • Fix NodeJs Permissions Problem
  • Take Full Page Screenshot in FireFox with No Addons like a Boss
  • My Calculator is Now NodeJs instead of Google or Excel
  • Node.js Installing on Ubuntu 14.04 and also NPM
  • Associate Tags & Categories with Custom Post Type – CPT & Make them Work on Archive Pages
  • SASS & SCSS to Super Charge CSS Skills
  • Bluefish Editor – Text Editor for Programmers
  • An offline version of Khan Academy
  • Happy New Year 2014 & Falling Snow until 4th jan
  • WordPress 3.8 I love Admin Interface
  • German City Starts Distributing Free Ubuntu 12.04 CDs to Windows XP Users
  • FireFox Responsive Web Design View RWD
  • Keep Height of Second Div column same as First Div
  • Using PTCL & WordPress – Two Unusual Issues I Faced Today
  • Surprise – The Biggest Bonus So Far & Joy of Working
  • Toastmasters Club Lahore
  • Giving Access to Specific Bucket in AWS using IAM
  • GiT Guide & Basic Commands for Git Beginners
  • Added Good Looking Pricing Table to MagicBox Website
  • Thank You WordPress
  • Yes You Can Do It _Watch it Now
  • 2Checkout Coupon Promo Code Get Free 2Co Account
  • Top Ubuntu Free Softwares We Use Everyday in Our Internet Business
  • Market Samurai – Great Customer Support
  • Bobby McFerrin hacks your brain with music
  • Start up File Helps Your Startup Business
  • Simply Awesome – Reunion With Old Friend
  • Fire the Complex, Go for Simple
  • Facebook Profile Nice & Clean Personal URL
  • Forget about todo list, Manage Your Energy
  • Credit Card Interest Rate Puzzle & Banker’s Bomb
  • Seven Best Free Tools I Use Everyday in my Business
  • Google Wave – Best Tips & Tricks for Users
  • Paypal in Pakistan? Response to a Friend
  • Google Apps – Future Of Business Communication
  • Flippa for Flipping, Good as Sitepoint?
  • Fit Reports Launched again at Fit dot com
  • How a Website is Created Online Exactly – Part -1
  • 2Checkout Owner Alan Homewood Interviewed
  • Uploading Files Fast Quick Tip
  • How to Delete All Those Spam Comments
  • WordPress as CMS Pages RSS Feeds
  • MySQL-Front What a Great Tool
  • Google Chrome Browser Background Problem
  • Quick Fix for WordPress Duplicate Content
  • WordPress Blog Tips
  • No Paypal, No Clickbank, No Problem