Getting the error (Setting up “ghost” mysql user. A CliError occurred.) while installing second ghost instance

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

:heavy_multiplication_x: 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:
? 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 for troubleshooting.

This topic was automatically closed 14 days after the last reply. New replies are no longer allowed.