jdbcTemplate连接数据库过程的问题

问题1：Unknown character set index for field '255' received from server.

原因：MySQL版本高，mysql的jar版本低。本地mysql 8.0 而jar为5.0.4

导致：mysql与jar的编码错乱引起的

解决：后换成8.0.19的jar即可。网址https://dev.mysql.com/downloads/connector/j/

问题2：The server time zone value '�й���׼ʱ��' is unrecogni...mysql时区报错

新版驱动惹得锅，默认为美国时区，修改如下 加上    ?serverTimezone=UTC

url: jdbc:mysql://localhost:3306/mybatis?serverTimezone=UTC

或url: jdbc:mysql:///mybatis?serverTimezone=UTC

 

问题3：sqlyog登录密码问题、错误码2058

 mysql命令行登录后输入

mysql>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

 

 

参考：

https://blog.youkuaiyun.com/qq_38674645/article/details/81105266

https://blog.youkuaiyun.com/jisuanjiguoba/article/details/100014214

https://jingyan.baidu.com/article/7908e85cda0de1af481ad22c.html