WordPress and MySQL v8

After a recent upgrade to MySQL version 8 my WordPress site was refusing to connect to the database, despite me checking that the username, password, and host were correct. After a little googling I hit this article which correctly suggested an authentication issue. It seems that the default authentication method in MySQL has been switched and WordPress, or at least my version, has yet to catch up. The problem was fixed by adding

 default_authentication_plugin=mysql_native_password 

to the relevant my.cnf file and then restarting MySQL.

Leave a Comment