How to unblock my own admin account after 5 failed login attempts?

Question

I entered the wrong admin password more than 5 times, so Drupal has blocked my entry.

I've change the user password directly in MySQL and then tried to login, but is still doesn't work. Also, if I click the request new password link, I don't get an e-mail.

How can I unblock my account?

Answer 1

To answer the question in your title (which appears to become more complicated following your actual question), you just need to clear the flood table in your database. If you're running Drush, then the following should sort you out:

drush php-eval 'db_query("DELETE FROM flood");'

Failing that, just clear the flood table from your database manually :)

Answer 2

Clearing the flood table will give the OP another 5 tries guessing the password. (And if he has messed with the password field directly in MySQL, the passord field may have become munged and therefore useless.)

Clearing the flood table will not allow him to login as admin, which is what I assume the OP actually want to do.

However, there are a couple of other drush commands that may be handy. The first will produce a one time password reset link for uid 1, the second sets a new password for user admin:

drush uli
drush upwd admin --password="newpassword"

Answer 3

Much better solution, which is noticeably absent from other posts about this:

drush user-unblock {username}

https://drushcommands.com/drush-7x/user/user-unblock/

EDIT: this still doesn't clear the 'flood' table, unfortunately, which is dumb. As others have mentioned, to actually enable login after drush user-unblock in the case of a user being blocked by too many login attempts, you have to get into the database and truncate (dump all data from) the 'flood' table.

As others have mentioned when asking this question, this seems problematic in a production environment.

As usual, someone has already made a module that adds drush commands to clear out the flood table: https://www.drupal.org/project/flood_unblock

Answer 4

If you are not much experienced with Drush kind of stuff, you can run the following sql in your phpmyadmin

DELETE FROM flood;

The same error can be happened if you tried same user name with 5 or more times

Answer 5

Just truncate the table flood

Truncate flood;