Does Ghost support MySQL 8.x.x?

[maxkoretskyi]

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!

[Kevin]

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.

[maxkoretskyi]

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

[unixandria]

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

[kurazav]

any updates to this?

[vikaspotluri123]

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

Ubuntu 20.04 and MySQL 8 support

I have tried to install Ghost on Ubuntu 20.04, but it fails at too many points. It would be great if Ghost supported this new operating system to install this publishing platform.

Ghost CLI 1.15.0 added preliminary support for this

Ubuntu 20.04 and MySQL 8 support

The latest release of the CLI (1.15.0) contains initial support for Ubuntu 20 / MySQL 8! As a reminder, these versions aren’t officially supported by Ghost (yet) so there may still be some issues to iron out. If you run into any issues, please create a post (or respond to an existing one) :)