Reset user password for your own Ghost blog

If you do not config mail up for your ghost blog,
it maybe a big problem once you lost your user password.
however, methods are always more than problems.
We can fix it up by reset it.

  1. Find out your database name in your ghost config, it is maybe in config.production.json
    "database": {
    "client": "mysql",
    "connection": {
    "host": "localhost",
    "user": "ghost-452",
    "password": "dade1b0565f2585e07c7",
    "database": "ghost_production_acm"
  2. Use mysql to reset the password.
    mysql -u root -p
    Enter the password for root account.
    mysql> use ghost_production_acm;
    mysql> select * from users;
    ghost use bcrypthash for the password.
    You can get bcrypt hash string from

mysql>update users set password='
$2b$10$PaL8tKcU4i0CsjRrM6BhROVQMwwLFw2HSx/kWlAUgja23fNllc2Fy' where email='your@email';

Additionally : if the account has been locked,

you can set status to active to unlock the account, like that:

update users set status = “active”;

mysql>flush privileges;

3.Restart your ghost blog and login again.
ghost restart

Subscribe to Post, Code and Quiet Time.

Don’t miss out on the latest issues. Sign up now to get access to the library of members-only issues.