jdbcTemplate连接数据库过程的问题

Bertha 。 2023-07-03 04:52 124阅读 0赞

### 问题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/][https_dev.mysql.com_downloads_connector_j]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2N4bTQzOTk_size_16_color_FFFFFF_t_70][]

## 问题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 ##

![20200202154108966.png][]

mysql命令行登录后输入

mysql>ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql\_native\_password BY '123456';

参考：

[https://blog.csdn.net/qq\_38674645/article/details/81105266][https_blog.csdn.net_qq_38674645_article_details_81105266]

[https://blog.csdn.net/jisuanjiguoba/article/details/100014214][https_blog.csdn.net_jisuanjiguoba_article_details_100014214]

[https://jingyan.baidu.com/article/7908e85cda0de1af481ad22c.html][https_jingyan.baidu.com_article_7908e85cda0de1af481ad22c.html]

[https_dev.mysql.com_downloads_connector_j]: https://dev.mysql.com/downloads/connector/j/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2N4bTQzOTk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20200202153757855.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2N4bTQzOTk=,size_16,color_FFFFFF,t_70
[20200202154108966.png]: https://img-blog.csdnimg.cn/20200202154108966.png
[https_blog.csdn.net_qq_38674645_article_details_81105266]: https://blog.csdn.net/qq_38674645/article/details/81105266
[https_blog.csdn.net_jisuanjiguoba_article_details_100014214]: https://blog.csdn.net/jisuanjiguoba/article/details/100014214
[https_jingyan.baidu.com_article_7908e85cda0de1af481ad22c.html]: https://jingyan.baidu.com/article/7908e85cda0de1af481ad22c.html