How to bulk delete WordPress comments in PHPMyAdmin

Any user working on the computer system has the option in quickly deleting all the WordPress comments by using MySQL or phpMyAdmin. This particular method has a recommendation for all advanced users. The first step is logging in to cPanel dashboard of your hosting account of WordPress. Once you can view the databases section, then the option is there to click on phpMyAdmin.  

Details associated with deleting WordPress comments and phpMyAdmin

Once you would be inside phpMyAdmin, then you can look out for locating your WordPress database. You can then view the page like this which would show all the WordPress database tables. 

From this position onwards, you will need to find two relevant tables. The significance of WordPress Installation in this regard will have a lot of importance. It is only after the installation of WordPress; viewing all tables will become possible. These two tables indeed would be ‘wpprefix_comments’ and ‘wpprefix_commentmeta’. Once you can find them, then select both of them by marking a check to their respective boxes positioned towards the left. Then you can surely scroll down and then make efforts for finding a drop-down menu which says “With Selected”.

You can then click on it and then select the option of “Empty” from the list. After this stage, you would be then asked to have confirmation if you can go ahead with this or not. You would have to click on ‘Yes” for deleting the entire comments from the database. A warning even would be demonstrated by PhpMyAdmin before you can empty the tables.

You can continue further after pressing the yes button. It will help you in deleting all the WordPress comments from your database. You would also have the option in deleting the entire comments of WordPress with the help of using MySQL console (the command line). You can do this by simply logging in to your MySQL console and then run this particular command. 

You would also be in a position to see the entire comments cause on your site get deleted as you may have noticed, that it is very much easy in bulk, deleting the comments of WordPress. The most important aspect is that with the help of using a plugin or with the help of phpMyAdmin, you can remove all the comments in no time.


That’s it; we hope this article will prove very valuable for you in quickly deleting all the comments in WordPress. We even hope that you should not struggle to understand all the easy steps in bulk, deleting the WordPress comments in phpMyAdmin. You can surely follow some more of our articles in the future to enhance your knowledge about WordPress further.

UNLIMITED DOWNLOADS: 50+ Million Website Templates & Design Assets

All the Website Templates you need and many other design elements, are available for a monthly subscription by subscribing to Envato Elements. The subscription costs $16.50 per month and gives you unlimited access to a massive and growing library of over 50 million items that can be downloaded as often as you need (stock photos too)!

Recent Articles

How to Change WordPress Theme If It Does Not Work (No Access to wp-admin) Through phpMyAdmin

Something is wrong. Your WordPress theme has got a blank screen and you can not log in to your admin through /wp-admin/...

How to Bulk Deactivate WordPress Plugins (No Access to WP-Admin) Through phpMyAdmin

Sometimes happens that you don't have any backups of your WordPress site (ups) and after your plugins update nothing works (ups, twice!),...

Landco – Garden & Landscaping WordPress Theme [Free WordPress theme download]

Demo Download Landco – Garden & Landscaping WordPress Theme Landco – Garden & Landscaping...

Optrica – Optometrist & Eye Care WordPress Theme [Free WordPress theme download]

Demo Download Optrica – A Premium WordPress Theme for all kind of optometrist...

Qwery – Multi-Purpose Business WordPress Theme + RTL [Free WordPress theme download]

Demo Download Giant Multi-Purpose Business Elementor WordPress Theme v1.0.4 Qwery is an innovative responsive...

Get in touch

Be our first-class reader, build a community and follow us on social media!

Leave A Reply

Please enter your comment!
Please enter your name here