# Does Ghost support MySQL 8.x.x?

**URL:** <https://forum.ghost.org/t/does-ghost-support-mysql-8-x-x/8500>\
**Category:** Developer help\
**Created:** [August 1, 2019, 2:18pm UTC](https://forum.ghost.org/t/does-ghost-support-mysql-8-x-x/8500 "2019-08-01T14:18:28Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![maxkoretskyi](https://avatars.discourse-cdn.com/v4/letter/m/58956e/32.png) [@maxkoretskyi](https://forum.ghost.org/u/maxkoretskyi)\
**Post date:** [August 1, 2019, 2:18pm UTC](https://forum.ghost.org/t/does-ghost-support-mysql-8-x-x/8500/1 "2019-08-01T14:18:28Z")

</div>

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!

---

<div class="post-metadata">

**Author:** ![Kevin](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/kevin/32/32_2.png) [@Kevin](https://forum.ghost.org/u/Kevin)\
**Post date:** [August 1, 2019, 2:24pm UTC](https://forum.ghost.org/t/does-ghost-support-mysql-8-x-x/8500/2 "2019-08-01T14:24:08Z")

</div>

[MySQL 8 is not supported](https://ghost.org/docs/install/ubuntu/#prerequisites).

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](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.

---

<div class="post-metadata">

**Author:** ![maxkoretskyi](https://avatars.discourse-cdn.com/v4/letter/m/58956e/32.png) [@maxkoretskyi](https://forum.ghost.org/u/maxkoretskyi)\
**Post date:** [August 1, 2019, 2:29pm UTC](https://forum.ghost.org/t/does-ghost-support-mysql-8-x-x/8500/3 "2019-08-01T14:29:56Z")

</div>

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`

---

<div class="post-metadata">

**Author:** ![unixandria](https://avatars.discourse-cdn.com/v4/letter/u/7ba0ec/32.png) [@unixandria](https://forum.ghost.org/u/unixandria)\
**Post date:** [November 15, 2020, 3:32am UTC](https://forum.ghost.org/t/does-ghost-support-mysql-8-x-x/8500/4 "2020-11-15T03:32:46Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![kurazav](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/kurazav/32/11000_2.png) [@kurazav](https://forum.ghost.org/u/kurazav)\
**Post date:** [January 1, 2021, 1:44pm UTC](https://forum.ghost.org/t/does-ghost-support-mysql-8-x-x/8500/5 "2021-01-01T13:44:46Z")

</div>

any updates to this?

---

<div class="post-metadata">

**Author:** ![vikaspotluri123](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/vikaspotluri123/32/24_2.png) [@vikaspotluri123](https://forum.ghost.org/u/vikaspotluri123)\
**Post date:** [January 1, 2021, 8:55pm UTC](https://forum.ghost.org/t/does-ghost-support-mysql-8-x-x/8500/6 "2021-01-01T20:55:35Z")

</div>

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

> [@Ubuntu 20.04 and MySQL 8 support](https://forum.ghost.org/t/ubuntu-20-04-and-mysql-8-support/14360):
>
> 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](https://forum.ghost.org/t/ubuntu-20-04-and-mysql-8-support/14360/12):
>
> 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) :)

---

<div class="post-metadata">

**Author:** ![vikaspotluri123](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/vikaspotluri123/32/24_2.png) [@vikaspotluri123](https://forum.ghost.org/u/vikaspotluri123)\
**Post date:** [January 1, 2021, 8:55pm UTC](https://forum.ghost.org/t/does-ghost-support-mysql-8-x-x/8500/7 "2021-01-01T20:55:40Z")

</div>



---

<div class="post-metadata">

**Author:** ![vikaspotluri123](https://sea1.discourse-cdn.com/flex015/user_avatar/forum.ghost.org/vikaspotluri123/32/24_2.png) [@vikaspotluri123](https://forum.ghost.org/u/vikaspotluri123)\
**Post date:** [January 1, 2021, 8:56pm UTC](https://forum.ghost.org/t/does-ghost-support-mysql-8-x-x/8500/10 "2021-01-01T20:56:21Z")

</div>


