A while back we discussed the Top 10 WordPress Plugins for Your WebSite, and in that we recommended Limit Login Attempts to help secure your website and inform you of any hacking attempts.
What happens if your user name gets locked out and you need immediate access?
Here we will outline all the steps necessary to reset your account. To start this you will need to access your WordPress database and the steps provides below are through using phpMyAdmin for executing a sql command.
Login to your web hosting control panel (such as cPanel, Plesk, etc) and click on your PHPMyAdmin option under databases.
Login to PHPMyAdmin and select your database used with your WordPress installation. Click on SQL tab and copy the sql update statement from the below block and paste into the SQL text field.
NOTE: The table ‘wp_options’ is the default name for a basic WordPress installation, if you have customized your table for security purposes you will need to modify the update statement below accordingly.
UPDATE wp_options SET option_value = '' WHERE option_name = 'limit_login_lockouts'
Click “GO” to execute the sql statement and results should appears similar to the image below, with a response of “1 row affected” confirming the update was successful and the lock cleared.