Get The Most Affordable Hosting in the World!
Starting at just $1.87/month, Vercaa offers unbeatable pricing for world-class web hosting services.
Fast, reliable, and secure hosting to power your website without breaking the bank. Plus, enjoy a free CDN for faster loading times worldwide!
Get Started Now!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.
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
The End! should you have any inquiries, we encourage you to reach out to the Vercaa Support Center without hesitation.