MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client

Question

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.Util.getInstance(Util.java:381)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:984)
    at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3558)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3490)
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:919)
    at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3996)
    at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1284)
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2137)
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:776)
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
    at java.base/jdk.internal.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
    at java.base/jdk.internal.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
    at java.base/java.lang.reflect.Constructor.newInstance(Unknown Source)
    at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
    at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:352)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:284)
    at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql/java.sql.DriverManager.getConnection(Unknown Source)
    at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:154)
    at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:145)
    at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:205)
    at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:169)
    at org.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
    at org.hibernate.engine.jdbc.env.internal.JdbcEnvironmentInitiator$ConnectionProviderJdbcConnectionAccess.obtainConnection(JdbcEnvironmentInitiator.java:180)
    at org.hibernate.resource.transaction.backend.jdbc.internal.DdlTransactionIsolatorNonJtaImpl.getIsolatedConnection(DdlTransactionIsolatorNonJtaImpl.java:43)

I get this error even after updating mysql password. I read in some posts that mysql has a new caching mechanism and all clients need to run the following which I already did but still the same error:

 update user set authentication_string='test' where user='root';
 flush privileges

Please check the version of the dependency and to the installed mysql server. — learn2code, May 31 '18 at 09:08
Yes u r right. The problem occurred with 8.11 version of mysql server. When I switched to 5.7 version, the problem went away — sirajnadwar, Jun 02 '18 at 17:30
Try solution suggested in following answer. [https://stackoverflow.com/a/50131831/2210710](https://stackoverflow.com/a/50131831/2210710) — Manoj De Silva, Nov 10 '18 at 08:06

score 15 · Answer 1 · edited Apr 27 '19 at 09:05

15

Step 1: Check the version of your current Mysql using: SELECT version(); query.

step 2: Check the version of Mysql jdbc driver or Mysql dependency in your maven.

step 3: Upgrade the jar version or the maven dependency version for Mysql.

edited Apr 27 '19 at 09:05

Iwo Kucharski

3,735
3
50
66

answered Sep 29 '18 at 23:31

suraz

309
1
4
8

score 13 · Answer 2 · answered Feb 09 '19 at 18:20

this issue can be rectified using below steps:-

step 1 :- run below query in mysql and restart it (for version >8.0 ,username is root here)

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword';

step 2:- check the version of your mysql by running select version(); in mysql

 the version of mysql in pom.xml should be same as the version of mysql installed (mine is 8.0.14)
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.14</version>

step 3:-if the mysql-connector jar file is not there in maven repository you can download the 8.0.14 version jar and can paste it in repository

$\.m2\repository\mysql\mysql-connector-java\8.0.14

step 4:- update your maven project

step 5:- check for driverClassName in config.xml, it should be "com.mysql.cj.jdbc.Driver".

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'yourpassword'; This worked for me! — Rohit Parte, Nov 13 '19 at 06:47
Same here, step 5 was crucial for me, I had "com.mysql.jdbc.Driver" — theomeli, Mar 17 '21 at 22:35

score 6 · Answer 3 · answered Aug 31 '18 at 15:27

I've done what the message suggests. I had in pom.xml:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>5.1.18</version>
</dependency>

and changed to the latest version:

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.12</version>
</dependency>

score 2 · Answer 4 · answered Jul 19 '18 at 20:52

2

check your mysql-connector-java-version.jar(ex: mysql-connector-java-8.0.11.jar) in the lib folder of your project and upgrade accordingly.

answered Jul 19 '18 at 20:52

parvinB

21
2

score 1 · Answer 5 · edited May 24 '18 at 12:08

You have to update the database user’s password using the OLD_PASSWORD function of MySQL. SOLUTION

For example:

[rajesh-tpl-01@home ~]$ mysql -u root -p mysql
Enter password:

mysql> update user set password=OLD_PASSWORD('password') WHERE 
user='username';
Query OK, 0 rows affected (0.02 sec)
Rows matched: 0  Changed: 0  Warnings: 0

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

score 1 · Answer 6 · answered Aug 21 '18 at 04:52

1

Just update u r mysql-connector-java to latest version no need any thing else

answered Aug 21 '18 at 04:52

uday

57
3

Actually that is what caused the issue in the first place – sirajnadwar Aug 27 '18 at 17:53

Aman Gupta · Answer 7 · 2018-09-01T16:23:53.960

1

The issue is with mysql-connector-java version 5.1.6. Try upgrading to version 5.1.44. Worked for me. I used the following dependency version:

compile group: 'mysql', name: 'mysql-connector-java', version: '5.1.44'

edited Sep 01 '18 at 16:23

answered Aug 26 '18 at 09:03

Aman Gupta

71
1
10

5.1.6 is an earlier version. Switching to 5.1.44 would be **upgrading**. – Mark Rotteveel Aug 31 '18 at 15:34

score 0 · Answer 8 · answered Sep 18 '18 at 05:52

0

Just update the version in POM.XML file, if problem is only regarding to the client version, just upgrade the latest version -> then clean project. It's successfuly run's.

answered Sep 18 '18 at 05:52

shubham

11
4

MySQLNonTransientConnectionException: Client does not support authentication protocol requested by server; consider upgrading MySQL client

8 Answers8

Linked