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