How to remove the 'Unable to load authentication plugin 'caching_sha2_password' issue in Netbeans while connecting to MySQL 8.0.19

The newer versions of MySQL default to caching_sha2_password. If you want to disable it then follow below steps

1. Login into your MYSQL console as root user like below.

eg mysql -uYOUR_ROOT_USER_NAME -pYOUR_ROOT_USER_PASSWORD

2. Then execute the command by replacing YOUR_ROOT_USER_NAME and YOUR_ROOT_USER_PASSWORD

ALTER USER 'YOUR_ROOT_USER_NAME'@'localhost' IDENTIFIED WITH mysql_native_password BY 'YOUR_ROOT_USER_PASSWORD';

You will no longer get any 'caching_sha2_password' exception while connecting for any client after this.

Source:
https://stackoverflow.com/questions/50193771/unable-to-load-authentication-plugin-caching-sha2-password