How to access sqlite database tables created by one-click Ghost installation on DigitalOcean?

Posted October 6, 2014 3.7k views

I created a droplet on DigitalOcean with one click Ghost installation. I know that the blog points to a sqlite database. But I am not sure how to access it. I also tried the sqlite3 command and it said that sqlite3 isn’t installed. Please advise

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

Submit an Answer
1 answer

You will need to install the sqlite3 package in order to use the sqlite3 command:

sudo apt-get install sqlite3

Then you can open your database with sqlite3:

sqlite3 /var/www/ghost/content/data/ghost.db