How to Reset the Drupal Administrator password with a SQL Query in Drupal 7

Drupal > How To

How to Reset the Drupal Administrator Password with a SQL Query in Drupal 7 on a Windows Server

If you are unable to retrieve the administrator password using the email link the following process can be used to retrieve the password. Note: Dedicated server customers are able to perform this task. Shared hosting customers must contact support for assistance with retrieving their password.

If you have reset the password but still receive "Sorry, there have been more than 5 failed login attempts for this account. It is temporarily blocked." you should delete the corresponding entry in the flood table. The flood table records user name and IP addresses from which failed login attempts have occurred.