Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver解决方案

在用java连接MySQL时报了Exception in thread "main" java.lang.ClassNotFoundException: com.mysql.jdbc.Driver这个错误

是在加载类的时候找不到该类，缺少对应的mysql-connector-java的jar包

下载连接：https://dev.mysql.com/downloads/file/?id=477057

我是用的是 mysql-connector-java-8.0.11.jar，导入该包

 

可能因为版本问题又报错

Exception in thread "main" 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 zone value if you want to utilize time zone support.

看提示信息是关于时区什么的错误，

这时在连接的数据库链接后面加上serverTimezone=GMT即可，如jdbc:mysql://114.xxx.xxx.xx:3306/xxxxx?serverTimezone=GMT

 

此外，会提示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.

这种信息，可能是版本更新了连接驱动，将`com.mysql.jdbc.Driver'改为`com.mysql.cj.jdbc.Driver'就行了