May 7, 2022 0

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

File Manager cpanel

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

public_html

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

wp-config

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

wp-config_databasename

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

phpMyAdmin

database

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

sql

Step::7 Add the following line in the box

DELETE from wp_comments WHERE comment_approved='0';

sample

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

go_ok

confirm

This will delete all WordPress comments from your database.

That’s it!!!

Written by