mysql8.0之后版本-连接常见错误

1.Connections could not be acquired from the underlying database
【mysql8.0之后版本-连接常见错误】原因:从描述来看不是密码错误,也不是路径错误,因为下载的MySQL workbench设置了自动更新,mysql-connector-java版本更新了
所以maven重新导入mysql-connector-java版本
2.The server time zone value '?D1ú±ê×?ê±??' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (viathe serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support.
原因:从描述来看是是时区的问题
解决方法:1. 在jdbcUrl后面添加时区属性: "?serverTimezone=GMT%2B8"
2.设置mysql全局属性

show databases; show variables like '%time_zone%'; set global time_zone='+8:00';


转载于:https://www.cnblogs.com/dengrong/p/10813103.html

    推荐阅读