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/