Open/close comments in Wordpress with phpmyadmin

[Brian Turner]

If you've enabled comments and found you only get spam (common) else disabled comments but get so much traffic users are complaining of not being able to comment, here's some handy code for you.

In most admin panels this is seriously easy.

For example, in CPanel, go to Databases, then PHPmyadmin.

Select the database.

Then click on SQL.

Then run the following code to close all comments:

UPDATE wp_posts SET comment_status = 'closed', ping_status = 'closed' WHERE comment_status = 'open';

or run the following code to open all comments:

UPDATE wp_posts SET comment_status = 'open', ping_status = 'open' WHERE comment_status = 'closed';

Simple and easy.

[Brian Turner]

Okay, just had to reference this again.