How to reset drupal admin password with sql-query?

Rest Drupal Admin Password

To reset drupal admin password when you lost it and email notification could not work mostly on localhost, then you can reset it with sql-query. For this you have to generate a password hash from following command.

Execute following command from command line, in Drupal root directory.

php .\scripts\password-hash.sh yourpassword

Note: If you get error that php is not recognized command then you need to set environment variable for php.

Note: change “yourpassword” with your desired password.

After this; execute the following query on drupal database.

UPDATE users SET pass = ‘$S$DkKBntGJ8OAHCyu.H9EYYRvokfk.Y8QjvpHI5FML1B7Okg0u970d’ WHERE uid = 1;

That’s it. Now you can login in your drupal admin with new password.