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

September 20, 2017 102 views
Ghost MySQL 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     : '',
              user     : 'ghost',
              password : 'xxxxxxx',
              database : 'ghost',
              charset  : 'utf8'
        // End of per-droplet configuration
        debug: false
Be the first one to answer this question.