You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2020/02/03 05:48:21 UTC
[GitHub] [incubator-shardingsphere] ryan8926 opened a new issue #4146:
sharding-proxy can not connect mysql 8.0.19
ryan8926 opened a new issue #4146: sharding-proxy can not connect mysql 8.0.19
URL: https://github.com/apache/incubator-shardingsphere/issues/4146
i need use spring-boot 2.1.7.RELEASE to connect sharding-proxy, but error !
mysql version is 8.0.19,i use mysql driver version is 8.0.19 and this jar in shardling lib also is 8.0.19, but my application start error, error :Caused by: com.mysql.cj.exceptions.UnableToConnectException: CLIENT_PLUGIN_AUTH is required.
![image](https://user-images.githubusercontent.com/20263758/73628580-9a384980-468b-11ea-8262-239eb3a4d48f.png)
![image](https://user-images.githubusercontent.com/20263758/73628636-c18f1680-468b-11ea-8a15-5834bb95b6ce.png)
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] RainElohim commented on issue #4146:
springboot can not connect mysql 8.0.19 by sharding proxy
Posted by GitBox <gi...@apache.org>.
RainElohim commented on issue #4146: springboot can not connect mysql 8.0.19 by sharding proxy
URL: https://github.com/apache/incubator-shardingsphere/issues/4146#issuecomment-584086144
proxy4.0.0
`[2020-02-10 19:28:30,434] [ERROR] [DruidDataSource:2755] ===> create connection SQLException, url: jdbc:mysql://10.16.0.21:3307/sharding_db?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true, errorCode 0, state 08001
java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.19.jar:8.0.19]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.19.jar:8.0.19]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.19.jar:8.0.19]
at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.19.jar:8.0.19]`
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4146:
springboot can not connect mysql 8.0.19 by sharding proxy
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4146: springboot can not connect mysql 8.0.19 by sharding proxy
URL: https://github.com/apache/incubator-shardingsphere/issues/4146#issuecomment-585653593
> proxy4.0.0
> `[2020-02-10 19:28:30,434] [ERROR] [DruidDataSource:2755] ===> create connection SQLException, url: jdbc:mysql://10.16.0.21:3307/sharding_db?serverTimezone=UTC&useSSL=false&allowPublicKeyRetrieval=true, errorCode 0, state 08001 java.sql.SQLNonTransientConnectionException: CLIENT_PLUGIN_AUTH is required at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110) ~[mysql-connector-java-8.0.19.jar:8.0.19] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97) ~[mysql-connector-java-8.0.19.jar:8.0.19] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89) ~[mysql-connector-java-8.0.19.jar:8.0.19] at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63) ~[mysql-connector-java-8.0.19.jar:8.0.19]`
the driver in your project should be changed to 5.1.47 too.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] RainElohim commented on issue #4146:
springboot can not connect mysql 8.0.19 by sharding proxy
Posted by GitBox <gi...@apache.org>.
RainElohim commented on issue #4146: springboot can not connect mysql 8.0.19 by sharding proxy
URL: https://github.com/apache/incubator-shardingsphere/issues/4146#issuecomment-584065569
> You can use mysql-driver with 5.1.47 and retry.
it's can't ,too
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4146:
springboot can not connect mysql 8.0.19 by sharding proxy
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4146: springboot can not connect mysql 8.0.19 by sharding proxy
URL: https://github.com/apache/incubator-shardingsphere/issues/4146#issuecomment-581282330
can you show some error details?
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] kimmking commented on issue #4146:
springboot can not connect mysql 8.0.19 by sharding proxy
Posted by GitBox <gi...@apache.org>.
kimmking commented on issue #4146: springboot can not connect mysql 8.0.19 by sharding proxy
URL: https://github.com/apache/incubator-shardingsphere/issues/4146#issuecomment-581744364
You can use mysql-driver with 5.1.47 and retry.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] tuohai666 closed issue #4146: springboot
can not connect mysql 8.0.19 by sharding proxy
Posted by GitBox <gi...@apache.org>.
tuohai666 closed issue #4146: springboot can not connect mysql 8.0.19 by sharding proxy
URL: https://github.com/apache/incubator-shardingsphere/issues/4146
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services
[GitHub] [incubator-shardingsphere] tuohai666 commented on issue #4146:
springboot can not connect mysql 8.0.19 by sharding proxy
Posted by GitBox <gi...@apache.org>.
tuohai666 commented on issue #4146: springboot can not connect mysql 8.0.19 by sharding proxy
URL: https://github.com/apache/incubator-shardingsphere/issues/4146#issuecomment-584456049
Duplicate with #3097.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
With regards,
Apache Git Services