参考:
- CSDN博主「txwtech」Unknown initial character set index ‘255’ received from server. Initial client character 解决方法
- the jar file has no source attachment解决
- l.shane 【坑】The server time zone value ‘�й���ʱ��’ is unrecognized or represents more than one time zone
- 下载jar包:仓库服务
- .navicat连接MySQL8+时出现2059错误解决方法
- 如何修复mysql 8.0.11连接报错2059?
出现的坑:
- 坑1
- 坑2
删除mysql-connector-java-5.1.18.jar文件后会出现下列问题
elipse mysql-connector-java-5.1.8.jar missing
打开如下窗口红线处会显示mysql-connector-java-5.1.8.jar missing,这时删除红线处内容,再选择Add JARs 添加mysql-connector-java-8.0.17.jar即可
- 坑3
删除mysql-connector-java-5.1.18.jar文件后再添加mysql-connector-java-8.0.17.jar文件会出现以下错误。
原因:用了最新的mysql 连接驱动
解决方法:需要添加mysql-connector-java-8.0.17-sources.jar文件
转载:the jar file has no source attachment解决
注:mysql-connector-java-8.0.17-sources.jar最好直接导入到lib下再单击“Attach Source…”按钮
按ctrl键 点击com.mysql.cj.jdbc.Driver出现Driver.class即可
- 坑4
set global time_zone=’+8:00’;
use spring;
show tables;