ER_NOT_SUPPORTED_AUTH_MODE - MySQL

Developer help Installation
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?