How to bulk delete spam comments in your WordPress website?

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 press OK to confirm

This will delete all WordPress comments from your database.

Visit our Blog for more detail. You can also watch the video here



 


 

  • wordpress, spam comments, delete spam comments in WordPress
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

How to Fix WordPress error “There has been a critical error on your website”

Step::1 First of all login to your cPanel and go to File ManagerStep::2 Go inside public_html and...

How to Stay Logged in for a longer period in your WordPress?

Step::1 First of all you must know the theme which is currently activated in your website. So...

How to Change WordPress logo in wp-admin page?

Step::1 Login to your cPanel and go to File Manager sectionStep::2 Now go to Public_html Step::3...

How to Change WordPress Admin Username?

Step::1 Login to your WordPress dashboardStep::2 Now at the same time login to your WordPress...

How to Set Default Timezone in your WordPress website?

If you want to set timezone as per your country’s location then in that case you just need to...