java – How to resolve Unable to load authentication plugin caching_sha2_password issue

java – How to resolve Unable to load authentication plugin caching_sha2_password issue

Starting with MySQL 8.0.4, they have changed the default
authentication plugin for MySQL server from mysql_native_password to
caching_sha2_password.

You can run the below command to resolve the issue.

sample username / password => student / pass123

ALTER USER [email protected] IDENTIFIED WITH mysql_native_password BY pass123;

Refer the official page for details: MySQL Reference Manual

Others have pointed to the root issue, but in my case I was using dbeaver and initially when setting up the mysql connection with dbeaver was selecting the wrong mysql driver (credit here for answer: https://github.com/dbeaver/dbeaver/issues/4691#issuecomment-442173584 )

Selecting the MySQL choice in the below figure will give the error mentioned as the driver is mysql 4+ which can be seen in the database information tip.


For


Rather than selecting the MySQL driver instead select the MySQL 8+ driver, shown in the figure below.


enter

java – How to resolve Unable to load authentication plugin caching_sha2_password issue

Upgrade your mysql-connector lib package with your mysql version like below i am using 8.0.13 version and in pom I changed the version:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <scope>runtime</scope>
    <version>8.0.13</version>
</dependency>

My problem has resolved after this.

Leave a Reply

Your email address will not be published.