After logging via wrong password your account may be locked and if you haven't config your email which makes
forget password work, you will never login to your dashboard forever.
But there is something we can do, that is, changing your password and unlock your account directly in database.
Find your db file in the location where Ghost has installed. Assume that it's
The db files should be in
Install Sqlite3 if you haven't done this before:
sudo apt-get install sqlite3
- Open database via sqlite3. Note that if your blog runs under production environment, you should open
ghost.dband if it's running under dev environment you should open 'ghost-dev.db':
sudo sqlite3 ghsot.db;
- Check your account:
select * from users;
Now you should see that there is one account which status is
BCrypt Hashpassword via
update from users set password="$2a$10$ImM7dqlGczqWk2gNFRP0tuXh6I0nTDxFbwv57tNEqDOAkcC/odICa" where id=1;
Note that the operation below changes password into
- Update your account status into
update from users set status="active" where id=1;
Now with correct email and password, you should login into your dashboard successfully.
Subscribe to JuniperPhoton's Blog
Get the latest posts delivered right to your inbox