Mysql8 Could not create connection to database server. Attempted reconnect 3 times. Giving up.

Mysql8 Could not create connection to database server. Attempted reconnect 3 times. Giving up.

1.包含检查服务名和密码, root / 123456
2.安装的MySQL是8.x ,mysql查询版本方法: SELECT VERSION();
将所有的driver-class-name值都从com.mysql.jdbc.Driver修改为com.mysql.cj.jdbc.Driver
3.MySQL安装的是版本8.0的 升级jar

	<dependency>
		<groupId>mysql</groupId>
		<artifactId>mysql-connector-java</artifactId>
		<version>8.0.13</version>
	</dependency>

4.修改连接参数:jdbc:mysql://localhost:3306/test?serverTimezone=UTC&autoReconnect=true&failOverReadOnly=false&zeroDateTimeBehavior=CONVERT_TO_NULL

posted on 2024-12-05 18:49  oktokeep  阅读(735)  评论(0)    收藏  举报