mysql8.0以上驱动版本，驱动名字要用cj那个，还有连接url地址最好加上编码和时区，避免连接不上

 常见错误：ERROR 19036 --- [ main] com.alibaba.druid.pool.DruidDataSource : init datasource error, url: jdbc:mysql://192.168.1.102:3306/db

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

 

原来的驱动名称和url配置格式（低版本mysql的）：

driver-class-name: com.mysql.jdbc.Driver
url: jdbc:mysql://192.168.1.102:3306/db

需要改成新的格式：

driver-class-name: com.mysql.cj.jdbc.Driver
url: jdbc:mysql://192.168.1.102:3306/db?useUnicode=true&characterEncoding=UTF-8&useSSL=false&serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=CONVERT_TO_NULL