spring:
datasource:
url: jdbc:mysql://39.xxxxx:3306/advance?characterEncoding=UTF-8
driver-class-name: com.mysql.cj.jdbc.Driver
username: aaaa
password: aaaa
这样配置的结果显示:
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
但是如果我用本地Mysql
spring:
datasource:
url: jdbc:mysql://localhost:3306/advance?characterEncoding=UTF-8
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: root
就成功写入数据库了2019-06-11 22:13:47.422 INFO 17876 --- [nio-8084-exec-3] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2019-06-11 22:13:47.565 INFO 17876 --- [nio-8084-exec-3] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.我的navicat可以成功连接到我的阿里服务器的mysql,请问这是怎么回事,求个解决方法!!
datasource:
url: jdbc:mysql://39.xxxxx:3306/advance?characterEncoding=UTF-8
driver-class-name: com.mysql.cj.jdbc.Driver
username: aaaa
password: aaaa
这样配置的结果显示:
com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failureThe last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
但是如果我用本地Mysql
spring:
datasource:
url: jdbc:mysql://localhost:3306/advance?characterEncoding=UTF-8
driver-class-name: com.mysql.cj.jdbc.Driver
username: root
password: root
就成功写入数据库了2019-06-11 22:13:47.422 INFO 17876 --- [nio-8084-exec-3] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Starting...
2019-06-11 22:13:47.565 INFO 17876 --- [nio-8084-exec-3] com.zaxxer.hikari.HikariDataSource : HikariPool-1 - Start completed.我的navicat可以成功连接到我的阿里服务器的mysql,请问这是怎么回事,求个解决方法!!
解决方案 »
- 关于如何用java调用webservice接口的问题
- 求大牛看看struts2关于文件上传的代码?不知道怎么解决
- 紧急求助。
- 高手速来,解决分多哦!!
- EJB问题
- 用axis的setMaintainSession后,怎么得到session id??????
- 一个很基础的XML问题~ 谢谢大家帮忙~
- jar文件的反编译问题(偶是合法滴)。。。
- struts问题, Cannot find message resources under key org.apache.struts.action.MESSAGE,解决就给分!!!
- Axis初级问题
- springboot获取项目路径
- 现成的maven构建的ssm项目导入 结果运行出错 求助
数据库8.0之后的连接和8.0之前的连接方式不同,可以查看本地的和linux上的数据库版本是否相同
具体怎么连接可以百度一下