Drupal 7. Recover, unblock admin account blocking after 5 failed login attempts.
If you get this message:
:Sorry, there have been more than 5 failed login attempts for this account. It is temporarily blocked. Try again later or request a new password."
after some failed login attempts and want to recover access to your site then you can do this via SQL using phpMyAdmin for example.
- Open phpMyAdmin infterface
- Find your Drupal database and browse the table 'flood'
- You will see records like:
1 failed_login_attempt_ip 127.0.0.1 1340134171 1340137771
2 failed_login_attempt_user 1-127.0.0.1 1340134171 1340155771
3 failed_login_attempt_ip 127.0.0.1 1340134206 1340137806
4 failed_login_attempt_user 1-127.0.0.1 1340134206 1340155806
5 failed_login_attempt_ip 127.0.0.1 1340134212 1340137812
6 failed_login_attempt_user 1-127.0.0.1 1340134212 1340155812
7 failed_login_attempt_ip 127.0.0.1 1340134219 1340137819
8 failed_login_attempt_user 1-127.0.0.1 1340134219 1340155819
9 failed_login_attempt_ip 127.0.0.1 1340134231 1340137831
10 failed_login_attempt_user 1-127.0.0.1 1340134231 1340155831
11 failed_login_attempt_ip 127.0.0.1 1340134240 1340137840
12 failed_login_attempt_user 1-127.0.0.1 1340134240 1340155840 - Check all these records and remove them
- Try to login