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.