首页 > 其他分享 >通过docker logs -f 容器号出现错误[ERROR] COLLATION ‘utf8_unicode_ci‘ is not valid for CHARACTER SET ‘latin1‘

通过docker logs -f 容器号出现错误[ERROR] COLLATION ‘utf8_unicode_ci‘ is not valid for CHARACTER SET ‘latin1‘

时间:2022-12-18 15:56:21浏览次数:35  
标签:ci SET logs utf8 character set unicode skip

解决办法:

将mysql的配置文件从

[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
[mysqld]
init_connect='SET collation_connection = utf8_unicode_ci' init_connect='SET NAMES utf8' character-set-server=utf8
collation-server=utf8_unicode_ci
skip-character-set-client-handshake
skip-name-resolve

修改为:

[client]
default_character_set=utf8
[mysql]
default-character-set=utf8
[mysqld]
collation_server = utf8_general_ci
character_set_server = utf8
skip-character-set-client-handshake
skip-name-resolve

再从行运行mysql容器就好了

标签:ci,SET,logs,utf8,character,set,unicode,skip
From: https://www.cnblogs.com/just1t/p/16990465.html

相关文章