seata mysql8.0 启动报错caching_sha2_password问题解决

gang_luo

发布于 2021-02-02 17:38:38

2.1K0

发布于 2021-02-02 17:38:38

文章被收录于专栏：gang_luogang_luo

本文参考https://cloud.tencent.com/developer/article/1783993

版本

seata版本1.3

mysq版本8.0

问题一

启动会发现控制台报错java.sql.SQLException: Unable to load authentication plugin 'caching_sha2_password'

解决办法

更改driverClassName = "com.mysql.cj.jdbc.Driver"

问题二

再次启动报错

Caused by: com.mysql.cj.exceptions.InvalidConnectionAttributeException: 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.