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.

Leave a Comment