Description
Currently, if you follow the install instructions in the documentation, but don't specify a root password when you're setting up mysql, Ghost-CLI will error when you try to run ghost install, because it can't connect to mysql.
This is due to a bug in the underlying mysql adapter: mysqljs/mysql#1507, which exists because specifying no password during mysql setup changes the auth mode of the r 67AC oot account, which the mysql adapter can't work with.
There's not anything we can do to fix this bug unfortunately, so what we can do to mitigate this issue:
- update documentation to add troubleshooting section, as well as section to tell people to specify a mysql root password on setup
- troubleshooting section needs to include the sql queries in this comment so that people have a way of getting their server into a state working enough that the CLI can use it.
- add an ER_NOT_SUPPORTED_AUTH_MODE check to catch this and output a helpful error message.