I am setting up the second ghost blog instance on the same droplet on digital ocean, and I have created the new folder tried to install it. however, I got the error of
Setting up “ghost” mysql user
A CliError occurred.
I have tried to reset the mySql root password, so I am sure that the password is correct for the root.
name@name:$ sudo mkdir -p /var/www/en
name@name:$ sudo chown name:name /var/www/en
name@name:$ sudo chmod 775 /var/www/en
name@name:$ cd /var/www/en
name@name:en$ ghost install
You are running an outdated version of Ghost-CLI.
It is recommended that you upgrade before continuing.
Run `npm install -g ghost-cli@latest` to upgrade.
✔ Checking system Node.js version
✔ Checking logged in user
✔ Checking current folder permissions
✔ Checking operating system compatibility
✔ Checking for a MySQL installation
✔ Checking memory availability
✔ Checking for latest Ghost version
✔ Setting up install directory
✔ Downloading and installing Ghost v2.22.2
✔ Finishing install process
? Enter your blog URL: https://example.com/blog/en
? Enter your MySQL hostname: localhost
? Enter your MySQL username: root
? Enter your MySQL password: [hidden]
? Enter your Ghost database name: en_prod
✔ Configuring Ghost
✔ Setting up instance
+ sudo chown -R ghost:ghost /var/www/en/content
✔ Setting up "ghost" system user
? Do you wish to set up "ghost" mysql user? Yes
✖ Setting up "ghost" mysql user
A CliError occurred.
Message: Error trying to connect to the MySQL database.
Help: You can run `ghost config` to re-enter the correct credentials. Alternatively you can run `ghost setup` again.
Debug Information:
OS: Ubuntu, v18.04
Node Version: v8.10.0
Ghost-CLI Version: 1.9.9
Environment: production
Command: 'ghost install'
Additional log info available in: /home/name/.ghost/logs/ghost-cli-debug-2019-05-22T19_55_54_454Z.log
Try running ghost doctor to check your system for known issues.
You can always refer to https://docs.ghost.org/api/ghost-cli/ for troubleshooting.