Authentication method ‘caching_sha2_password’ not supported by any of the available plugins

[Edwin Eu]

Hello
I have XYZ application run into errors of “Authentication method ‘caching_sha2_password’ not supported by any of the available plugins” when trying to connect MySQL 8 databases.
• After I migrated MySQL 5 databases into MySQL 8 in Windows Server 2019.
• I make sure the logins to use “mysql_native_password” plugin.
• Then, I changed the INI parameter to use:
o default_authentication_plugin=mysql_native_password
Then, I checked and verified the logins plugin and it showed “mysql_native_password”
SELECT user, authentication_string, plugin, host from mysql_user;
• User name = Login_1
• Authentication_string = xxxxxx
• Plugin = mysql_native_password
• Host = %
Would someone please help and advise.
Thank you in advance for your help.
-Edwin