How do I set up a new mysql instance for a second ghost blog?

September 20, 2017 1.1k views
MySQL Ghost Ubuntu 16.04

I set up a one-click ghost install droplet to support two domains with unique blogs, following How to serve multiple ghost blogs on one vps (now quite out of date). The problem is that the tutorial references sqlite3. Has anyone done this recently with mysql?

Here’s what one sees:

database: {

            // This part was prepared during first boot by DigitalOcean's 1-Click first-provisioning
            // This section is unique to this droplet
            client: 'mysql',
                connection: {
                  host     : '127.0.0.1',
                  user     : 'ghost',
                  password : 'xxxxxxx',
                  database : 'ghost',
                  charset  : 'utf8'
            // End of per-droplet configuration
            },
            debug: false
        },
edited by asb
Be the first one to answer this question.

You can type !ref in this text area to quickly search our full set of tutorials, documentation & marketplace offerings and insert the link!