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

标签: none

文章分类

归档