ER_NOT_SUPPORTED_AUTH_MODE - MySQL

Developer help Installation
1

ghost-cli-stack-overflow-nate-madore
ghost-cli-stack-overflow-nate-madore3790×1295 185 KB

If you’re looking for some help, it’s important to provide as much context as possible so that people are able to assist you. Try to always mention:

  • What’s your URL? This is the easiest way for others to debug your issue - https://neutronnebulo.us
  • What version of Ghost are you using?
  • What configuration? 4.7.0
  • What browser? Firefox
  • What errors or information do you see in the console? ER_NOT_SUPPORTED_AUTH_MODE
  • What steps could someone else take to reproduce the issue you’re having? Install ubuntu 20.4 with latest version of virtualmin.
2

I am having the same issue:

Message: 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

Debug Information:
    OS: Ubuntu, v20.04.2 LTS
    Node Version: v14.17.2
    Ghost Version: 4.8.4
    Ghost-CLI Version: 1.17.3
    Environment: production
    Command: 'ghost start'

This installation was upgraded from 2.x and will not connect to MySQL 8. How do we solve this?

EDIT: Allegedly Ghost works with MySQL 8 and I should not be seeing this error as per this post:

@Kevin Do you know if there is a way to solve this?

3

I will double check to make sure that MySQL 8 is installed. Thank you!