We will use a Mysql query to approve all the comments in your wordpress database at once.
Login to Phpmyadmin
Select the wordpress’s database
Go to ‘SQL’ tab and put the following code.
UPDATE wp_comments SET comment_approved = 1;
Note: The comments in Trash and Spam categories would also be approved, so keep them clean before issuing the above command.
Suggested WordPress Plugins:
- Hide Comment Author Link
- Minimum comment length
- No Comment Links
- Remove html comments
- Short Comment Filter
- WTC Comment Cleaner