Strictly following the Ubuntu install guide on Ubuntu 22.04 fails, because the `root` MySQL user gets created with `auth_socket` auth, not a password about ghost-cli HOT 6 OPEN

Some further commentary:

mysql2, the library you use to connect to MySQL, supports socket-based connections like this...

conn = mysql.createConnection({socketPath: '/var/run/mysqld/mysqld.sock', user: 'root'})

... but obviously you'd need to run that from within a process that's running as root, which seems awkward since you deliberately don't allow ghost install to be run as root.

Maybe the best approach here is to run the commands to create the Ghost user via the shell using your ui.sudo function, only when the host is localhost, the user is root, password auth has failed, and a Ghost user needs creating? I'm not sure if I'm overcomplicating things here and the better solution is just a docs changing telling the user to give root a password...

from ghost-cli.

Also ran into this error when using Digital Oceans 1-click droplet. Most of what you said above went straight over my head. Is there a quick fix before someone looks at the bug?

from ghost-cli.

@carrickspeirs yes - see the instructions in the quote block that I suggest adding to the docs. Basically the fix is:

1. Run ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'somepassword';
2. Enter somepassword as the root password when installing Ghost

It's unfortunate we have to do this, though, because it weakens the security of our MySQL install a bit.

from ghost-cli.

You're right, our docs need work here. We should be able to tidy these up next week 🙂

from ghost-cli.