How to reset my Drupal administrative password?
You can easily change your Drupal password through a database-modification tool like phpMyAdmin
Once you access the app, select the database Drupal is using. Then open the interface to execute SQL queries. In it enter the following query:
update users set pass=md5(‘PASSWORD’) where uid = 1;
This will set the password for your admin username to PASSWORD. You can substitute this string in the query to set a password for your own.
