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

October 6, 2014 3.1k 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

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
Have another answer? Share your knowledge.