This article presents a number of ways that you can reset either your administrator or other passwords within Drupal. The administrator, or user 1, account controls everything about who and what can access your site. Keeping this login secure is critically important. Use the following methods to attempt to recover your password:
Reset password link
You can use the reset password link from either the sign in page, or directly from http://[site_URL]/user/password (where http://[site_URL]/is your website's URL).
Other administrative users
In larger organizations, more than one person may have access to administer users. Check with other primary site administrators to reset your password.
Drush
You can also use Drush to reset your website's password. This method is useful for situations where the person with the admin email address is not available.
Use the following Drush command from the Drupal installation directory on your server to obtain a one-time login link, the same as you would receive from the password reset email:
drush uli --uri=http://www.sitename.com/where http://www.sitename.com/ is your website's URL.
For more Drush command info, run drush help uli.
Database query
This method requires that you to have access to your website's database, and is typically done using the command line or through a GUI interface (such as phpMyAdmin).
For additional steps for resetting the password manually using a database query, see http://drupal.org/node/1023428.
More Information
Recovering the administrator password
Drush
Resetting the administrator password with sql-query