cobar icon indicating copy to clipboard operation
cobar copied to clipboard

mysql-connector-java 高版本的会出现以下异常,低版本正常。

Open copyshop opened this issue 8 years ago • 4 comments

java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:526) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:513) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:505) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:479) at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:489) at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:72) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1606) at com.mysql.cj.jdbc.ConnectionImpl.(ConnectionImpl.java:633) at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:347) at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:219) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) Goodbye! at com.letcode.study.Main.main(Main.java:26) Caused by: com.mysql.cj.core.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:423) at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:54) at com.mysql.cj.core.exceptions.ExceptionFactory.createException(ExceptionFactory.java:73) at com.mysql.cj.mysqla.io.MysqlaProtocol.rejectConnection(MysqlaProtocol.java:327) at com.mysql.cj.mysqla.authentication.MysqlaAuthenticationProvider.connect(MysqlaAuthenticationProvider.java:207) at com.mysql.cj.mysqla.io.MysqlaProtocol.connect(MysqlaProtocol.java:1414) at com.mysql.cj.mysqla.MysqlaSession.connect(MysqlaSession.java:132) at com.mysql.cj.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:1726) at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:1596) ... 6 more

copyshop avatar Sep 12 '17 01:09 copyshop

@copyshop hey did you find a resolution for this issue ? Best Regards,

jeankhawand avatar Oct 06 '19 21:10 jeankhawand

you can use lower version than this. otherwise you can modify mysql CLIENT_PLUGIN_AUTH . I string recommend use sharding-sphere this link https://shardingsphere.apache.org/document/current/cn/quick-start/

copyshop avatar Oct 09 '19 01:10 copyshop

you can use lower version than this. otherwise you can modify mysql CLIENT_PLUGIN_AUTH . I string recommend use sharding-sphere this link https://shardingsphere.apache.org/document/current/cn/quick-start/

English doc:I strong recommend use shardingsphere ,this link https://shardingsphere.apache.org/document/current/en/quick-start/

copyshop avatar Oct 09 '19 01:10 copyshop

@copyshop Thanks

jeankhawand avatar Oct 09 '19 10:10 jeankhawand