Hi. I am installing Ghost on my VPS. Everything installs well, but after the ghost start command this error appears.
Ghost was able to start, but errored during boot with: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client Help: Unknown database error
The solution offered here - https://github.com/mysqljs/mysql/issues/1507 is not suitable as another error appears.
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(''), plugin='mysql_native_password' where user='root'' at line 1
Version MySQL - 8.0,
OS: Ubuntu, v20.04.3 LTS
Node Version: v14.17.6
Ghost Version: 4.12.1
Ghost-CLI Version: 1.17.3
Site - scripstr.ru