Friday, March 20, 2020

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

  1. 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


No comments:

Post a Comment

How can I run a C++ program directly from Windows?

How-can-I-run-a-C-program-directly-from-Windows