{"id":2399,"date":"2012-10-10T16:44:35","date_gmt":"2012-10-10T20:44:35","guid":{"rendered":"https:\/\/www.inmotionhosting.com\/support\/2012\/10\/10\/320-wordpress-comment-spam\/"},"modified":"2021-08-16T23:34:08","modified_gmt":"2021-08-17T03:34:08","slug":"wordpress-comment-spam","status":"publish","type":"post","link":"https:\/\/www.inmotionhosting.com\/support\/edu\/wordpress\/wordpress-comment-spam\/","title":{"rendered":"Clean Up WordPress comment spam"},"content":{"rendered":"

<\/a><\/p>\n

In this article we\u2019ll explain how you can clean up and remove spam comments from your WordPress database directly using phpMyAdmin.<\/p>\n

This is a bit more advanced than simply managing your comments in WordPress<\/a> directly.<\/p>\n

A major benefit of doing it this way, is if you\u2019re dealing with a large amount of spam comments mixed in with legitimate comments in the WordPress database.<\/p>\n

    \n
  1. First you\u2019ll need to get to your WordPress database via the phpMyAdmin interface<\/a><\/li>\n
  2. Navigate to your wp_comments<\/strong> table, and click Browse<\/strong>\"wp-comments-browse\"<\/a>\n
    <\/div>\n<\/li>\n
    \u00a0<\/div>\n
  3. These are the common WordPress comment rows you\u2019ll work with:comment_post_ID
    \ncomment_author
    \ncomment_author_email
    \ncomment_author_url
    \ncomment_author_IP
    \ncomment_content<\/li>\n
  4. \n
    Click on the comment_post_ID <\/strong>column to sort by that column.\n

    Sorting by comment_post_ID<\/strong> is a quick way to see if just one of your posts is being comment spammed, as you\u2019ll see all of the comments for that post one after another. In this example we can see our post ID #32<\/strong> is filled with various \u201cpayday\u201d<\/em><\/strong> spam users.<\/p>\n<\/div>\n

    \"wp-comments-sort-comment-post-id\"<\/a><\/p>\n

  5. Now you can delete comments a few ways<\/li>\n

    Single entry removal<\/h2>\n

    Click on Delete<\/strong> beside the comment you want to remove, then click OK<\/strong> in the pop-up:<\/p>\n

    \"wp-comments-delete-single-entry\"<\/a><\/p>\n

    <\/div>\n

    \"wp-comments-delete-single-entry-ok\"<\/a><\/p>\n

    <\/div>\n
    \u00a0<\/div>\n

    Multiple entry removal via checkboxes<\/h2>\n

    You can click on the checkboxes beside each entry you wish to remove, scroll to the bottom of the page and click on Delete<\/strong>, and finally click on Yes<\/strong> on the next page to confirm the deletion.<\/p>\n

    \"wp-comments-delete-multi-checkbox\"<\/a><\/p>\n

    <\/div>\n

    \"wp-comments-delete-multi-delete-button\"<\/a><\/p>\n

    <\/div>\n

    \"wp-comments-delete-multi-delete-confirm\"<\/a><\/p>\n

    <\/div>\n
    \u00a0<\/div>\n

    Either of these options should help you quickly clear up small spam outbreak.<\/p><\/ol>\n

    When you have a more extensive spam outbreak, there are more advanced methods for cleaning these up. Please take a look at these other options below as well:<\/p>\n