Reset a Lost Drupal Administrator Password

Your first step should be to try and reset your password by adding this to your site's URL: /user/password/. If that doesn't work or if you don't know the email for the account, then you can manually reset your password in the database. Here's how to do it:

Access your database. In thix example we're gong to use phpMyAdmin. If you're using commercial hosting then phpMyAdmin will be access from your hosting control panel. On XAMMP and other local apache installations also have methods for getting to phpMyAdmin.

If you have more than one database, be sure to select the correct one to work with from the left hand column.

Scroll down and click on the users table. Choose the Browse tab at the top of the right hand panel.

Scroll down to see your user entries. The headers may be kind of large and it looks like empty tables. The users are listed below the headers.

Find user 1 - the user number is next to the user name. Drupal ALWAYS makes user 1 the administrator. Don't ever delete user 1.

Click the pencil-edit icon.

Select MD5 from the dropdown menu.

Type in a brand new password.

If you're done, you can scroll to the bottom of the page and click "Go" and your password will now be changed.

After you click "Go" you will see that the password has been encrypted. It has been changed and you can now log in with your new password.

To change the email, type a new email in the mail field. There is no need to make a selection from the drop down box if you are changing the email.

Click Go to save your changes.

You can do this at the same time as resetting the password, or in a separate step.

To directly reset your password, log into phpMyAdmin and execute the following mySQL statement:

UPDATE users SET pass = md5('newpassword') WHERE uid = 1;

Enter your new password in the md5 function - it will automatically be converted via a one-way hash (this is why we can't retrieve your old password - the decryption is a one-way process). Note that for earlier versions of Drupal you may need to use SET password, instead of SET pass.

This will effectively reset the Drupal admin password for user 1. Note that you can use this to reset the password of any user, although this is typically unnecessary as you should be able to simply log in as admin user (user 1), under which you have the ability to reset any user's password.