MySQL问题汇总

问题：Mysql：Unknown initial character set index ‘255’ received from server

原因：使用的字符集不同

解决方案：

​ 修改 jdbc.properties 文件中的url

url=jdbc:mysql://localhost:3306/xxxxx?characterEncoding=utf8

xxxx为项目名，只需要在项目名后修改编码方式为utf8即可

问题：Mysql：Client does not support authentication protocol requested by server; consider upgrading MySQL client

解决方案：

ALTER USER 'username'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
flush privileges;

这里username填使用的用户名

localhost填数据库的访问地址

password填当前数据库的登录密码

原因详见：[MySQL 8.0 - Client does not support authentication protocol requested by server; consider upgrading MySQL client

问题：Mysql：RuntimeError: Target host is configured as windows, but seems to be a different OS. Please review the connection settings

解决方案：

打开后点击