Does Ghost support MySQL 8.x.x?

Does Ghost support MySQL 8.x.x? I tried to configure MySQL in config.development.json on Windows 10 and got the error:

Message: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Is there anything extra I need to do? Thanks!

MySQL 8 is not supported.

Ghost can be made to run against MySQL 8 but you’ll need to adjust the password hashing and maybe some other things because MySQL 8 changed the auth defaults which are not currently supported by Ghost-CLI. MySQL 8.0.11 removed support for old_password · Issue #833 · TryGhost/Ghost-CLI · GitHub may have some further information that could help.

If you’re unsure what you are changing, downgrading to an earlier MySQL version is probably the best route until MySQL 8 is fully supported.

1 Like

Got it, thanks! What about nginx? The page you linked only mentions the minimum version:

  • NGINX (minimum of 1.9.5 for SSL)

I current have nginx/1.14.0 with the latest being 1.17.2

Please note downgrading if you have existing databases is not possible and will kill your existing databases so that is extremely bad advice

any updates to this?

I’m going to close this topic in favor this one:

Ghost CLI 1.15.0 added preliminary support for this