连接MySQL 报错"init datasource error, url: jdbc:mysql:/" 解决

最新推荐文章于 2024-08-15 08:42:24 发布

kainx

最新推荐文章于 2024-08-15 08:42:24 发布

阅读量3.5w

点赞数 19

分类专栏：问题文章标签： mysql maven jdbc

本文链接：https://blog.csdn.net/qq_26545503/article/details/104879286

版权

问题专栏收录该内容

30 篇文章 0 订阅

订阅专栏

原因

原来数据库5.5升级到8.0后，数据库连接配置没有改造成的

解决办法

1、驱动包要升级为 mysql-connector-java-8.0.11.jar 或更新的版本
https://dev.mysql.com/downloads/file/?id=477058

Maven 依赖:

<dependencies>
	<dependency>
    	<groupId>mysql</groupId>
    	<artifactId>mysql-connector-java</artifactId>
    	<version>8.0.11</version>
	</dependency>
</dependencies>

2、JDBC driver 由com.mysql.jdbc.Driver改为com.mysql.cj.jdbc.Driver
3、url中加上“useSSL=false”。否则会出现以下错误：

“Establishing SSL connection withoutserver's identity verification is not recommended. According to MySQL 5.5.45+,5.6.26+ and 5.7.6+ requirements SSL connection must be established by defaultif explicit option isn't set. For compliance with existing applications notusing SSL the verifyServerCertificate property is set to 'false'. You needeither to explicitly disable SSL by setting useSSL=false, or set useSSL=trueand provide truststore for server certificate verification.”

4、url中加上“serverTimezone=GMT%2B8”（GMT%2B8代表东八区）否则会报关于时区的错

一个完整配置的例子:

spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql:/localhost:3306/mysql?characterEncoding=utf8&useSSL=false&serverTimezone=GMT%2B8
spring.datasource.username=root
spring.datasource.password=yourpassword