WordPress can’t connect to the latest MySQL 8.x Server?

After migrating WordPress, WP can’t seem to login to the new MySQL container even when the password is correct.

Official Info: https://mysqlserverteam.com/upgrading-to-mysql-8-0-default-authentication-plugin-considerations/

As of MySQL 8.0, by default, it uses an auth plugin called, “caching_sha2_password”. This is not something supported by a good number of applications yet including WordPress. So a…