Reset my Drupal Admin Password
There are two ways to change the admin password of your Drupal website:
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:
drush user-password someuser --password="enter-new-password"
where someuser is the name of the actual user.
drush user-password admin --password="myNewDrupalpassword931"
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!