目录

  1. 字符集问题
  2. mysql 插入中文，报错：ERROR 1366 (HY000): Incorrect string value: ‘\xE5\xBC\xA0\xE4\xB8\x89’ for column 'name
  3. 彻底解决 mysql 中文乱码
  4. 解决：The server time zone value ‘�й���׼ʱ��’ is unrecognized or represents more than one time zone
  5. 附录

本文主要记录平时使用 MySQL 时遇到的问题

字符集问题

1
2
3
SELECT CONCAT(IFNULL(commission_pct,'无'),',',job_id) AS 'OUT_PUT' FROM employees;
Illegal mix of collations (utf8_general_ci,COERCIBLE), (utf8_general_ci,COERCIBLE),
(gb2312_chinese_ci,IMPLICIT) for operation 'concat'

mysql 插入中文，报错：ERROR 1366 (HY000): Incorrect string value: ‘\xE5\xBC\xA0\xE4\xB8\x89’ for column 'name

https://blog.csdn.net/u013155359/article/details/94392050

彻底解决 mysql 中文乱码

https://blog.csdn.net/u012410733/article/details/61619656

解决：The server time zone value ‘�й���׼ʱ��’ is unrecognized or represents more than one time zone

https://blog.csdn.net/wxb141001yxx/article/details/104959538

附录

远程 mysql 出现 ERROR 1130 (HY000): Host ‘172.17.42.1’ is not allowed to connect to this MySQL server
docker 下的 Mysql 镜像的使用方法
MYSQL 表名大小写设置
Docker 容器内 Mysql 大小写敏感方案解决
连接器的区别