Ghost blog broken on upgrade to MySQL 8.4
If it ain't broke, don't fix it
I was doing a sweep of all my apps on my Unraid server and updating a few docker containers and compose stacks.
Because of the nature of how I defined the stack to pull in mysql:8
Self-Hosting a Ghost Blog on Your Homelab Using Unraid + Docker
I’ve been meaning to post my thoughts and ideas in blog format; not necessarily so that I can educate/entertain anyone (although it’s great if I’m somehow accidentally achieving that), but more so that I can perhaps document things I can later come back to. Seems only fitting I should
I've inadvertently pulled in the latest 8.4 image and ran into this
latest image has no connection · Issue #1048 · docker-library/mysql
I have an CI/CD that is configured to run integration tests and it uses mysql docker image for it. Previously it run without problem, but today all tests are failed cause cannot connect to database…
docker-libraryNot that I think anyone reads my posts, so the fact my site was down was purely self-discovered.
Quick solution - change this
command: '--default-authentication-plugin=mysql_native_password'to something like this
command: '--mysql-native-password=ON'... and your ghost site should be back up and running.
Thoughts
- If you haven't already upgraded, perhaps stick to 8.3 or even better 8.0 (which I think is going to be supported for a while)
- Even with 8.4, the native password plugin is deprecated and you'll see warnings in the logs
- I should investigate options around authentication here, but I don't have the time to research this now. I have a workaround, and it is functional with my site back up again
- 8.4 does seem to be a LTS version though, so perhaps for the time being I should explicitly state that version/stream - at least so that I don't run into any surprises when 9+ inevitably get released
MySQL :: Introducing MySQL Innovation and Long-Term Support (LTS) versions