IDEA 连接数据库报错

1. 版本问题

1.1 概述

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Client

1.2 解决方式

连接的mysql数据库是8.0版本，而项目使用com.mysql.jdbc.Driver驱动包是5.1版本，将项目驱动版本改成8.0.11可以解决。

2. 驱动弃用

2.1 概述

Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class is com.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.

2.2 解决方式

报错意思就是说com.mysql.jdbc.Driver这个驱动已经被弃用了，新的驱动为com.mysql.cj.jdbc.Driver，通常是自动注入的。

所以，我们只需要按照提示，将“com.mysql.jdbc.Driver”驱动改为“com.mysql.cj.jdbc.Driver”。

3. 时区报错

3.1 概述

控制台报错信息：
java.sql.SQLException: The server time zone value ‘�й���׼ʱ��’ is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time

3.2 解决方式

解决方式1
show variables like ‘%time_zone%’;

mysql> show variables like "%time_zone%";
+------------------+--------+
| Variable_name    | Value  |
+------------------+--------+
| system_time_zone |        |
| time_zone        | SYSTEM |
+------------------+--------+

设置为东八区（北京时间）

mysql> set global time_zone='+8:00';
Query OK, 0 rows affected (0.00 sec)

解决方式2
不加版本号或者版本号为6以上，解决方式：在连接数据库的配置文件中加上以下，时区亚洲/上海

Loading class `com.mysql.jdbc.Driver'. This is deprecated. The new driver class is `com.mysql.cj.jdbc.Driver'. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.