mysql8.0 jdbc连不上_mysql8.0 jdbc连接注意事项

作者：你好赵伟 | 2024-06-10 11:44:57

踩

mysql8.0启动后,jdbc不能连接,需要启动工具先连一次

该楼层疑似违规已被系统折叠隐藏此楼查看此楼

url增加参数useSSL 和时区 : jdbc:mysql://localhost:3306/mydb?useSSL=false&serverTimezone=UTC

driver变化: com.mysql.jdbc.Driver => com.mysql.cj.jdbc.Driver

常见错误提示1：

如果driver没有添加cj，则会在连接的时候出现以下错误提示：

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：

url中如果没有设置useSSL=false，则会在连接的时候出现以下错误提示：

WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements
SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the v

声明：本文内容由网友自发贡献，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：【wpsshop博客】