IDEA连接MySQL踩过的坑

常见问题一：

• Exception in thread “main” com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server.
• mysql-connector-java-5.1.37-bin.jar包和本地的MySQL Server 8.0版本不匹配问题
• 建议下载高版本的mysql-connector jar包
  下载步骤
  https://dev.mysql.com/downloads/connector/j/
  
  根据需求选择
  
  

常见问题二：

• Loading class com.mysql.jdbc.Driver'. This is deprecated. The new driver class iscom.mysql.cj.jdbc.Driver’. The driver is automatically registered via the SPI and manual loading of the driver class is generally unnecessary.
• 注册驱动文件引入有误
• 规范写法：Class.forName(“com.mysql.cj.jdbc.Driver”);
• 可在jar包中查看(版本6之后注册驱动可以省略)
  

常见问题三：

• 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.
• 6版本之后地jar包，url书写不规范会引发时区问题
• 解决方案：规范书写url

jdbc:mysql://localhost:3306/db1    //错误写法

jdbc:mysql://localhost:3306/db1?serverTimezone=UTC   //正确写法