How to Manually Add a WordPress Administrator to the Database using SQL Queries

May 19, 2015 Iyngaran Iyathurai 0

In a recent WordPress hack attack which we worked on and recovered, the owner’s WordPress administrator account was demoted to a user role, therefore the owner did not have any control over the WordPress installation. To regain back access to WordPress, we manually created a new WordPress user with an Administrator role directly in the database.   In this tutorial I will show you how to manually create a WordPress administrator in the WordPress database […]

Bulk delete pending wordpress comments

April 10, 2015 Iyngaran Iyathurai 0

Been under a comment spam attack lately? Or you just did not have time to delete spam comments over several months and you now have hundreds of spam comments that needs be deleted page by page using the wordpress admin? Don’t worry, there are a couple of easy ways to bulk delete pending comments in your wordpress blog. Method 1: Direct MySQL Query If you know yourself around phpMyAdmin and MySQL queries, just run this […]