How to bulk delete spam comments in your WordPress website? [STEP BY STEP]☑️
Here in this tutorial you will learn how to easily bulk delete spam comments from your WordPress website. Let me tell you that deleting spam comments manually could be time consuming that is why we recommend to bulk delete spam comments in WordPress using phpMyAdmin.
Video Tutorial– How to bulk delete spam comments in your WordPress website
Follow the steps to Delete All WordPress Comments Using phpMyAdmin:
Step::1 Login to your cPanel and click on File Manager section
Step::2 Go to public_html and then open your WordPress installation directory
Step::3 Find wp-config.php and right click over the file and choose the View option
Step::4 From here you can know the Database Name of your WordPress site
Step::5 Once you know the Database name, go back to cPanel homepage and open phpMyAdmin under DATABASE section
Step::6 Now click over the associated database and then tap on SQL
Step::7 Add the following line in the box
DELETE from wp_comments WHERE comment_approved='0';
Step::8 Click on Go button and then OK to confirm
This will delete all WordPress comments from your database.
Thanks for Reading this article !!! We hope this was helpful to you all.