java连接mysql错误及解决方案整合

1.java.sql.SQLException: Unknown system variable 'query_cache_size'

mysql-connecter-java的版本过低

解决方案

修改mysql依赖的版本

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>8.0.12</version>

</dependency>

2.The server time zone value 'Öйú±ê׼ʱ¼ä' is unrecognized or represents more than one time zone....

时区错误

解决方案

set global time_zone='+8:00'; 3.The name of the class that implements java.sql.Driver in MySQL Connector/J has changed from com.mysql.jdbc.Driver to com.mysql.cj.jdbc.Driver. The old class name has been deprecated. 或者 Could not create connection to database server

mysql驱动需要更新，下面语句

<jdbcConnection driverClass="com.mysql.jdbc.Driver"

connectionURL="jdbc:mysql://localhost:3306/imooc-video-dev"

userId="root"

password="">

</jdbcConnection>

改为

<jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"

connectionURL="jdbc:mysql://localhost:3306/imooc-video-dev"

userId="root"

password="">

</jdbcConnection>

mysql依赖语句也要更改

<dependency>

<groupId>mysql</groupId>

<artifactId>mysql-connector-java</artifactId>

<version>8.0.12</version>

</dependency>

4.WARN: Establishing SSL connection without server'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 default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.

解决方案

修改数据库连接语句connectionURL

<jdbcConnection driverClass="com.mysql.cj.jdbc.Driver"

connectionURL="jdbc:mysql://localhost:3306/imooc-video-dev?useSSL=false"

userId="root"

password="">

</jdbcConnection>

网址：java连接mysql错误及解决方案整合 https://www.yuejiaxmz.com/news/view/35884

相关内容

【Java报错已解决】Driver class ‘net.sourceforge.jtds.jdbc.Driver’ could not be found, make sure the
Navicat for MySQL安装及使用教程
MYSQL启动失败解决方法
基于微信小程序的个人账本的设计与实现/个人财务管理系统/基于java的财务管理系统
【独家源码】ssm家庭维修服务系统小程序bt23x计算机毕业设计问题的解决方案与方法
基于Java个人财务管理系统设计实现(源码+lw+部署文档+讲解等)
通用生活记账app/基于android记账系统/财务管理系统
基于java+ssm+jsp的个人财务管理系统
java计算机毕业设计宠物寄托管理系统（开题+程序+论文）
java健康饮食管理系统(ssm)

随便看看