How to reset the admin password for Ghost blog

This tutorial will show you how to reset the admin password for Ghost blogs

You might accidentally update your admin email in the author's information part, please make sure that you log in with the new email you've just updated in your author's information. You can try to recover your password from the built-in feature of Ghost blog: Reset your password with email (Email server must be configurated). If you forgot your password/admin email and/or can't use the Reset Password feature, you can access the database. You can try to follow the steps below:

1. Encrypt a new password with Bcrypt Generator, your new password, for example, password "123456" will be encrypted into this: $2a$12$pH.uTnzZsbve65Dl8hzoYeoJoHH4bvHnDbYzeASerUEWZ3JR18Eqi
2. (Required if running Docker) Connect to Docker container that runs MySQL to alter the password
3. Connect to MySQL database using the following command:
   mysql -u <<YOUR_USERNAME>> -p'<<YOUR_PASSWORD>>'
4. (Optional) In case you forgot the email, you can show all records for users table or query your email in users table: SELECT * FROM <<YOUR_DATABASE_NAME>>.users;
5. Execute the following MySQL command to update the password, use your encrypted password from step 1: UPDATE <<YOUR_DATABASE_NAME>>.users SET password='<<NEW_PASSWORD>>' WHERE email = '<<ADMIN_EMAIL_ADDRESS>>';
6. Navigate back to Ghost admin page to log in again