WordPress: How to turn off the comments option

Turning off the comments option

1. First you need to log into your phpMyAdmin control applet

2. Now locate and select your WordPress database on the left from the database dropdown list

3. Now select the SQL tab from the navigation tabs at the top

4. Within the Run SQL Query box add the following code and click go:

UPDATE wp_posts p SET comment_status = ‘closed’, ping_status = ‘closed’ WHERE comment_status = ‘open’;

5. If you get an error, check your wp_post prefix from the database list and change the code to match accordingly

If successful, you should have disabled the ability to comment on your posts across your entire blog.

To globally enable or re-enable comments, simply use the following code:

UPDATE wp_posts p SET comment_status = ‘open’, ping_status = ‘open’ WHERE comment_status = ‘closed’;

From: lancelhoff.com