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

Derivatives stock list at NSE

Complete FNO stock list at NSE. ABB India Ltd ACC Ltd APL Apollo Tubes Ltd AU Small Finance Bank Ltd Aarti Industries Ltd Abbott India Ltd A...