Errors After Upgrading to MySQL 9.0

I recently ran into an error with my Wordpress/mysql docker containers since I was using mysql-native-password and MySQL 9.0 removed support for the native password plugin. I think I was using that flag because of this very helpful DigitalOcean Guide for installing Wrodpress with Docker Compose.

Getting out of it was a bit tricky because once you upgrade to MySQL 9.0 you can’t roll back to 8.x, so you have to find a way to fix the authentication entries in the database by hand. I hope that writing up my steps here will save someone else some frustration when they hit this same problem.