Hello I am running Ghost 1.21.1 on Ubuntu 16.04 on Digital Ocean. I forgot the admin email address and password (I think I used a throwaway) and I had password protected the page and forgot that password. I still have access to the Digital Ocean droplet but I can’t seem to disable any of these settings. Any suggestions on how I can get the content or disable the password protection from the server level?

http://www.farmsoftstudios.com/blog/2014/01/web-applications/resetting-your-ghost-blog-password/ Have you tried Google or Bing or DuckDuckGo?

Thanks @andy1247008998 but I don’t see any ghost.db file under ‘/var/www/ghost/current/content/data’ (I also checked ‘/var/www/ghost/versions/1.21.1/content/data’), only a README.md. And I know there is data in the Ghost blog. I also don’t have the mysql database password so I can’t export the data out of mysql either…

Hey there! You’re going to have to look into your database for the information you’re looking for, but it shouldn’t be too difficult! In your terminal, cd into your ghost installation directory. run ghost config get database.client - it will either output sqlite3 or mysql If it says sqlite3, you can find the database by running ghost config get database.connection.filename With sqlite3, you can try to use the terminal to find the data you want, but I personally would download the database using sftp or your favorite file retrieval method and use an sqlite browser to find the data you want. I use https://sqlitebrowser.org/ If it says mysql, you can find the database config by running ghost config get database.connection.host for the host ghost config get database.connection.user for the username ghost config get database.connection.password for the password ghost config get database.connection.databse for the database With those details, you can get into mysql by running mysql -u {username} -p{password} {database} (assuming the host is localhost) Run SELECT value FROM settings WHERE key='password'; to get the password for the frontend of your site. For sqlite, switch to the Browse Data tab and choose settings from the dropdown. Use the filter input field under key and search for password. Your password will be under the value row Run SELECT email FROM users; to get the list of email addresses registered with ghost. For sqlite, use the users table and browse the email column. Once you have the email, you can reset your password from the frontend, which should get you access to your blog! Let me know if you want me to go more in depth about anything! p.s. you don’t have to use ghost config ..., but I personally advise people to use it to prevent any unintended consequences

Forgot All Credentials

Developer help

andy1247008998 July 11, 2018, 8:43pm 4

Your db password is in config.production.json.

Topic		Replies	Views
Don't know my ghost login and can't move site to prod Memberships & subscriptions	1	675	April 18, 2022
Lost password on local install with no mail config Developer help	9	6967	October 12, 2018
Password reset, unable to do it, even writing to the db Using Ghost	6	589	January 16, 2025
Update MySQL Password Developer help	3	1183	December 16, 2020
Locked out of Ghost account with no mail setup Developer help	1	1706	July 10, 2018

Forgot All Credentials

Related topics