How to Delete Mass WordPress Comments Using phpMyAdmin ?

Recently I helped a customer that had accumulated over 2578 spam comments on her blog. She tried removing them from the Word Press dash board however it only removes 20 comments at a time. This would take forever because there multiple pages of comments to delete.

• Go to phpmyadmin in your cpanel - Once you’re logged in cpanel click on the mySQL databases icon then click on the phpmyadmin link at the bottom of the page.
• Click your Word Press database link at phpadminnow – This is located in the top left and will display all the data in tables.
• Remove all comments – Note: If you want to remove all comments check the wp_comments table then in the drop down box select empty then press go. Remember this will remove both approved and unapproved comments.

Tags: cpanel, Delete Mass, Mass Comments, phpMyAdmin, spam