Reset password for Ghost from database

In case you have forgotten your Ghost admin user but still have access to database you can use the following 2 steps to reset your password:

• Connect to your database
• Find the user you want to reset the password to

select * from users;

• Generate the password using Bcrypt algorith. You can do this by using an online tool like https://bcrypt-generator.com/. Or generate the hash by running an inbuilt function in your favorite language (PHP)

echo password_hash('yourpassword', PASSWORD_BCRYPT)."\n";

• Once you have the password and user you want to update use the following SQL to update

mysql> update users set password = "{YOUR_HASHED_PASSWORD}" where id = {USER_ID};

That is it. You should be able to login using yourpassword

This is useful in case you have forgotten the password and the forgot password function is not working.