6对比5的主要区别是驱动和地区
1.JDBC连接Mysql5:
driverClassName=com.mysql.jdbc.Driver
url=jdbc:mysql://localhost:3306/xingyu4j?&useUnicode=true&characterEncoding=UTF-8&useSSL=false
username=root
password=
2.JDBC连接Mysql6:
driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC&zeroDateTimeBehavior=convertToNull&useUnicode=true&characterEncoding=UTF-8&useSSL=false
username=root
password=
3.JDBC连接Mysql8:
driverClassName=com.mysql.cj.jdbc.Driver
url=jdbc:mysql://localhost:3306/test?serverTimezone=UTC&zeroDateTimeBehavior=CONVERT_TO_NULL&useUnicode=true&characterEncoding=UTF-8&useSSL=false
username=root
password=
4.MySQL连接慢
编辑/etc/mysql/my.cnf (不同安装方式版本位置不同,具体位置 find / -name my.cnf 查询)
在[mysqld]下面加入
skip-name-resolve
保存后重启mysql