How to bulk delete spam comments in your WordPress website?

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

How to bulk delete spam comments in your WordPress website

Step::2 Go to public_html and then open your WordPress installation directory

How to bulk delete spam comments in your WordPress website

Step::3 Find wp-config.php and right click over the file and choose the View option

How to bulk delete spam comments in your WordPress website

Step::4 From here you can know the Database Name of your WordPress site

How to bulk delete spam comments in your WordPress website

Step::5 Once you know the Database name, go back to cPanel homepage and open phpMyAdmin under DATABASE section

How to bulk delete spam comments in your WordPress website

Step::6 Now click over the associated database and then tap on SQL

How to bulk delete spam comments in your WordPress website

How to bulk delete spam comments in your WordPress website

Step::7 Add the following line in the box

DELETE from wp_comments WHERE comment_approved='0';

How to bulk delete spam comments in your WordPress website

Step::8 Click on Go button and then OK to confirm

How to bulk delete spam comments in your WordPress website

How to bulk delete spam comments in your WordPress website

This will delete all WordPress comments from your database.

Thanks for Reading this article !!! We hope this was helpful to you all.

For more information, kindly follow us on social media like Twitter and Facebook and for video tutorials, subscribe to our YouTube channelhttps://youtube.com/redserverhost.com 

Facebook Page https://facebook.com/redserverhost

Twitter Pagehttps://twitter.com/redserverhost.com

If you have any suggestions or problems related to this tutorial, please let us know via the comment section below.

Tags: cheap linux hostingbuy linux hostingcheap reseller hostingbuy reseller hostingbest reseller hostingcheap web hostingcheapest web hostingcheapest reseller hosting,  cheap reseller hostcheap linux hostcheapest linux hostingbest linux hostingbest web hosting

Scroll to Top