docker mysql 修改默認編碼為 utf8

官方文檔 》》》》
官方說明docker mysql安裝默認編碼可以如此設置

docker run name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci

完整docker 命令

docker run -p 3306:3306 restart always name mymysql -v /etc/localtime:/etc/timezone:rw -v /etc/localtime:/etc/localtime:rw -e MYSQL_ROOT_PASSWORD=asdf@#123 -d mysql:5.6 character-set-server=utf8mb4 collation-server=utf8mb4_unicode_ci

然後修改docker /ect/mysql/conf.d/mysql.cnf

[client]
default-character-set=utf8
[mysql]




default-character-set=utf8

show variables like "%char%";