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

2021-02-02 17:38:38 浏览数 (1)

本文参考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.

解决办法

url后添加?serverTimezone=UTC

成功启动

再次启动成功

0 人点赞