Bulk remove wordpress spam comments and Akismet metadata

Aug 6, 2014

Connect to your wordpress DB using MySql workbench and execute this query:

DELETE FROM wp_comments WHERE comment_approved = 0;
DELETE FROM wp_commentmeta WHERE comment_id NOT IN (SELECT comment_id FROM wp_comments);
DELETE FROM wp_commentmeta WHERE meta_key LIKE '%akismet%';