Posts tagged Wordpress

How to mass delete comments in WordPress



To mass delete comments in the WordPress admin panel, follow these steps:

  1. Log in to the WordPress admin panel and go to the “Comments” section.

  2. On the comments page, you will see a list of all the comments on your site. You can select multiple comments by clicking the checkbox next to each comment you want to delete.

  3. Once you have selected the comments you want to delete, scroll to the top or bottom of the comments list and look for the “Bulk Actions” dropdown menu.

  4. Select “Move to Trash” from the dropdown menu. This will delete the selected comments from the site.

  5. To permanently delete the comments, go to the trash section and select the comments you want to delete permanently and click on “Empty trash” or you can also select all the comments and delete it once.

Note that deleting comments permanently will remove them from the site permanently and it will not be recoverable.

Additionally, in case you have thousands of comments and you want to delete all of them, you can use a plugin such as “Delete All Comments” or “Bulk Delete” to delete comments in bulk. These plugins will enable you to select and delete comments based on different criteria, such as date, author, and more.

WordPress also has an inbuilt feature to approve, unapprove, mark as spam, move to trash and delete comments in bulk. It can be found by clicking on the checkbox on the top of the comment list, which will give you option to perform bulk actions on selected comments.

It’s always a good practice to take a backup of your website before making any major changes.


You can also go to plugins -> Add new plugin and search the WP Bulk Delete plugin and use that to delete more than the allowed page comments at once.

You do not have sufficient permissions to access this page” after WordPress upgrade


If you’ve done a wordpress upgrade which included either copying another wp database or changing the current one’s table prefix (as well as changing the $table_prefix PHP variable in your config file,) you will most likely be met with this warning when you try to log in:

You do not have sufficient permissions to access this page.

The reason for this is that everything in wordpress that accesses info in the db does so from PHP using the $table_prefix variable, and when you first installed your blog, a couple of options are set in the database that include that value, which makes it not really so dynamic! 😉

After rooting through my db, I found 5 or 6 values that still had the old table prefix in – mostly in the `usermeta` table, but also one in the `options` table. To make sure I got them all, I ran these simple SQL statements in phpMyAdmin to update all the values:

_usermeta table and _options table
Go to Top