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.