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 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.