Does Ghost support MySQL 8.x.x?

Developer help
#1

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!

#2

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. https://github.com/TryGhost/Ghost-CLI/issues/833 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
#3

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

#4

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

#5

any updates to this?

#6

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

Ghost CLI 1.15.0 added preliminary support for this

#7
#10