Jdbc连接Docker中mysql连接不上问题排查1:docker中mysql跟宿主机做了端⼝映射,允许任意ip访问
2:本地Navicat 可以连接docker 中 mysql
3:jdbc连接不上报错如下:
wInstance0(Native Method) ~[na:1.8.0_192]
wInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_192]
wInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_192]
at wInstance(Constructor.java:423) ~[na:1.8.0_192]
sql.jdbc.Util.handleNewInstance(Util.java:400) ~[mysql-connector-java-5.1.36.jar:5.1.36]
navicat for mysql连接不成功
sql.Instance(Util.java:383) ~[mysql-connector-java-5.1.36.jar:5.1.36]
4经过⼀些列排查最终定位问题为mysql驱动包版本太低不能驱动⾼版本mysql,
old:
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>5.1.36</version>
</dependency>
new:
升级mysql驱动包后成功连接上数据库