Reset my Drupal Admin Password

There are two ways to change the admin password of your Drupal website:

  • phpMyAdmin

To change the Drupal admin password via phpMyAdmin you should:

  • Go to your cPanel -> Databases box -> phpMyAdmin.
  • Select the database which Drupal use from the drop-down menu on the left.
  • Click on the SQL tab.
  • In the text field on the page type the following text:

update users set pass=md5(’NEWPASS’) where uid = 1;

Change NEWPASS with the desired new administrative password. Then click on the GO button and if no errors present, the Drupal password should have been changed.

  • Using Drush over SSH

Drush is a command line interface that allows you to manage your Drupal web sites via SSH. You can use the following commands over SSH (applicable for Drupal 7.x and 8.x websites) and change the password of your admin user:

where someuser is the name of the actual user.

Example:

By running this command we've changed the password of the admin user to myNewDrupalpassword931.

If you are having problems resetting your Drupal password yourself, you may ask your host for assistance. SiteGround provides the best Drupal hosting and such requests are handled with ease.

You find this article useful? Click here to learn more about SiteGround web hosting experts and what else we can do for you!