This article describes how to reset the Ghost administrator password.
Normally if you forget your password, you can use the Ghost password recovery feature to reset the password by e-mail. However, if this option is unavailable (for example, if e-mail on your site is not working correctly), you can use phpMyAdmin to manually reset the password in the database.
The quickest and easiest way to reset the administrator's password is to request a new one through e-mail. To do this, follow these steps:
You can also modify the administrator password directly in the database using phpMyAdmin. To do this, follow these steps:
In the left-hand pane of phpMyAdmin, click the Ghost database. A list of tables in the database appears.
Copy and paste the following statement into the SQL query text box. Replace BcryptHash with the hash value you obtained in step 1, and replace [email protected] with the e-mail address associated with the account:
UPDATE users SET password = 'BcryptHash' WHERE email = '[email protected]';
If your Ghost installation uses table prefixes, make sure you add it to the users table. For example, if your Ghost table prefix is gho_, you would type the following command instead:
UPDATE gho_users SET password = 'BcryptHash' WHERE email = '[email protected]';
You should now be able to log in to Ghost as the administrator using the new password.
If the account is locked, you must also reset its status to active. The following SQL query demonstrates how to do this:
UPDATE users SET status = 'active' WHERE email = '[email protected]';