springboot项目连接mysql库异常Malformed database URL 或Communications link failure
连接mysql报错Malformed database URL,或者 Communications link failure
Springboot项目启动连接数据库注意以下错误:
1 连接mysql时出现的异常信息:(com.mysql.cj.exceptions.WrongArgumentException: Malformed database URL, failed to parse the connection string near......
2 com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
原因:mysql在5以后的驱动程序和连接串写法都发生了变化。
以前:
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/db_oasys?useUnicode=true&characterEncoding=UTF8?autoReconnect=true
以后:
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/db_oasys?useUnicode=true&characterEncoding=utf-8&useSSL=false&serverTimezone=GMT
pom中的依赖注意要改成相应版本。
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.13</version>
<scope>runtime</scope>
</dependency>
更多推荐
所有评论(0)