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.