Question

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

Posted May 10, 2016 2.3k views
UbuntuGhost

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?

Thanks.

Add a comment
setec
By:
setec
Add a comment

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.

×
2 answers
FrancisPBaker May 10, 2016

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

http://support.ghost.org/config/

Hope this helps

Reply Report
  • setec May 10, 2016

    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.

    Reply Report
setec May 13, 2016

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. ”

Reply Report
Submit an Answer

Related

Looking for something else?

Ask a new question Search for more help