Question
How do I set up a new mysql instance for a second ghost blog?
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
},