How to fix mysql-native-password errors with MySQL 9.0 and Wordpress
Jacob -
-
2 mins read
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.