Wordpress - Create administrator account

Hi, I've accidentally locked myself out from the back end of a wordpress site. I've had a quick look at the access levels etc via phpmyadmin, and even created a temporary admin user to no avail. There seems to be a redirect / restriction in place on the site which has locked out every user. Plugins in use include: 1. Login Security Solution 2. Wordfence 3. s2Member 4. WP Approve User 4. bbPress Your task: Restore admin account or create a new admin level account with all access rights across the site capable of accessing the admin dashboard or back-end of the website. Thanks