How can I determine the username and password necessary to access the database for ghost one click image?

Posted May 10, 2016 3.7k views

I need to manually access the database for a one click ghost image installation.

How can I find the username and password necessary to get into the database? What is the easiest way to access it from a OS X? Will sequal pro work with sqlite used by the ghost installation like it does with the MySQL for WordPress?

What port does the database server ghost is running on use?


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
2 answers

Here is some basic information on ghost database setup on there website:

Hope this helps

  • I am looking more for the username and password in Digital Ocean’s configuration for root access to the DB server but I found one thing that works. You can:

    apt-get install sqlite3
    cd /var/www/ghost/content/data
    sqlite3 ghost.db

    Then you will have command line access to the database. Not as convenient as GUI with sequal pro but it gets the job done if you know what you are looking for.

    The WordPress one click install from Digital Ocean has the root username and password for the MySQL server in the motd. I am looking for that for the ghost image but I haven’t found it yet.

Here is the answer from support:

“Thank you for getting in contact with us!

Ghost actually uses a SQLite database file for its connections. It would be located within the Ghost document root at content/data/ghost.db

This is a file based datastore. It shouldn’t require any authentication unless the file is encrypted which it typically is not. ”