Drupal 8 → How to manually reset an admin password on CentOS

This is a walk-through on how to reset an admin password in Drupal 8.

  1. Log into Mysql and go to your Drupal’s schema
  2. Find the users_field_data table
  3. Find the user that is related to you.
  4. Log into your terminal
  5. Go to your Drupal main directory
  6. Run this command
php core/scripts/password-hash.sh “NewPasswordHere”

Don’t forget the quotes in the above example

It will create a hash you can use in your database.

  1. Go back to your DB table
  2. Replace the pass value with your new hash. Save/update your table’s row.
  3. Go to flood table in DB
  4. If you are running a non-production server, simply truncate this table, otherwise look for anything that is flagging your IP with logging in. delete those records.
  5. Go to cache_entity table in DB
  6. If you are running a non-production server, simply truncate this table, otherwise look for anything that is flagging your IP with logging in. delete those records.
  7. Now you should be ready to log in with the new password. Go your login page on your site and try again!

Happy Coding!