OS: Ubuntu, v18.04.4 LTS
Node Version: v12.18.0
Ghost Version: 3.29.1
Ghost-CLI Version: 1.14.1
Environment: production
Command: ‘ghost setup’
Hello there - I’m following the instructions outlined here :
https://imaweb.dev/set-up-multiple-ghost-blogs-on-one-digital-ocean-droplet/
to install multiple blogs on a single droplet.
I’m getting these errors on ‘ghost setup’ every time :
- CliError
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.
- GhostError
Message: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
Help: Unknown database error
Suggestion: journalctl -u ghost_thiskindofthing-is -n 50```
I’ve checked that my mysql root password is entered correctly (against the config.production.json file) and am banging my head trying to work out what I’m doing wrong.
I’m not a CLI expert by any means, so any pointers would be really appreciated!|
Are you using Ubuntu 18.04?
If so then check the Mysql authentication mode… Make sure its set to use native_password
type sudo mysql if you can login to mysql server console with the command that means your mysql auth mode is set to auth_socket mode… you need to switch it to native password mode my running below command
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
FLUSH PRIVILEGES;
It seems I was running it in mode, so I ran the command, however I’m now getting a different error…
- ConfigError
Error detected in the production configuration.
Message: ER_ACCESS_DENIED_ERROR: Access denied for user ‘root’@‘localhost’ (using password: YES)
Configuration Key(s): database.connection.user / database.connection.password
Current Value(s): root / password_here
Help: You can run ghost config to re-enter the correct credentials. Alternatively you can run ghost setup again.
I’m now also finding that I can’t run sudo. mysql -u root -p in order to connect to mysql anymore… Is that right?
sorry! I take it back. I did the stupidest error possible… 
Seems password issue did you changed the password on the command ?
if not your current password is passoword
Login to mysql with the password password & then rerun the above command with your original password & it will work
yeah that’s what I did wrong…
embarassed…
Works great now, thanks so much for your help!
1 Like
You are welcome… Happy to help.
Cheers!
Hello! Tried doing the same, but on Vultr instead. Works about the same, but somehow I cannot understand how to get one domain pointing at one IP-address and another domain pointing at the second address.
The domain fake-space.com is pointing towards IP address 78.141.208.234 and on the server the folder is located on Ubuntu 16 at /var/www/ghost
The domain fakepilot.com is pointing towards IP address 185.92.221.8 and another Ghost is running on /var/www/fakepilot.com
Still, both fake-space.com and fakepilot.com are showing the /var/www/ghost folder?
OK, solved it myself. I did not need a secondary IP-address.
On the server, on /etc/nginx/enabled-sites/ there should be a .conf for each domain and -ssl.conf. I was missing a -ssl.conf for the fakepilot.com-ssl.conf…