Blog writers love comments because it makes their blog engaging and people also love comments because they know the value of feedback or pre-asked questions. It saves their time and helps them to have trust in any blog contents. In this post, I will show you that how to delete WordPress comments using phpMyAdmin, without using any third party plugins. This is the easiest way to delete comments from database in WordPress.
There are many reasons for anyone to delete WordPress comments. Might be someone made many dummy comments at the time of development of any blog or someone is tired due to spam comments. Or someone decided not have any comments on his blog and wants to disable comments feature.
Learn how easily you can delete WordPress comments using phpMyAdmin:
It is very easy to delete WordPress comments in bulk in one click. Follow few steps as given:
1- Login to your control panel
2- Open phpMyAdmin.
3- Locate your database and select it.
4- You will see all database table right side
5- Select top two wp_comments and wp_commentmeta table. For me, these are sv_comments and sv_commentmeta, because, I used SV_ prefix instead of WP_ at the time of installing WordPress. You will see prefix whatever you used.
There are two ways to delete all comments after selecting sv_commentmeta and sv_comments.
Let me show you both method to delete comments:
I- First Method:
Click on Empty given in front of each (Highlighted in violet color in above picture).
It will ask you to confirm whether you want to truncate table or not?
Once you clicked on OK and your comments will be deleted.
Note: Here, you have to truncate table one by one. It will not truncate both together. Select one first and truncate it and then select the second one and truncate it.
II- Second Method:
Select top two wp_comments and wp_commentmeta table. For me, these are sv_comments and sv_commentmeta.
After selecting both table scroll down the page until the end. Here, select Empty from With Selected drop-down box.
After selecting Empty, it will ask for your permission to execute a query to truncate comments, Click on Yes.
You will see that all comments have been deleted from your WordPress Blog. There are many plugins to delete WordPress comments in bulk but this is the easiest way to remove them.