docker环境下mysql终端无法输入中文的问题解决

docker环境下mysql终端无法输入中文的问题解决

进入容器

docker exec -it 容器id /bin/bash

输入命令查看容器支持的编码

root@f9cab59805c2:/# locale -a
C
C.UTF-8
POSIX

查看容器现在的编码格式

root@f9cab59805c2:/# locale
LANG=
LANGUAGE=
LC_CTYPE="POSIX"
LC_NUMERIC="POSIX"
LC_TIME="POSIX"
LC_COLLATE="POSIX"
LC_MONETARY="POSIX"
LC_MESSAGES="POSIX"
LC_PAPER="POSIX"
LC_NAME="POSIX"
LC_ADDRESS="POSIX"
LC_TELEPHONE="POSIX"
LC_MEASUREMENT="POSIX"
LC_IDENTIFICATION="POSIX"
LC_ALL=

修改容器编码格式为C.UTF-8

bashroot@f9cab59805c2:/# cat ~/.bashrc
root@f9cab59805c2:/# echo "export LANG=C.UTF-8" >> ~/.bashrc
root@f9cab59805c2:/# source ~/.bashrc

重启容器 在查看编码格式

root@f9cab59805c2:/# locale
LANG=C.UTF-8
LANGUAGE=
LC_CTYPE="C.UTF-8"
LC_NUMERIC="C.UTF-8"
LC_TIME="C.UTF-8"
LC_COLLATE="C.UTF-8"
LC_MONETARY="C.UTF-8"
LC_MESSAGES="C.UTF-8"
LC_PAPER="C.UTF-8"
LC_NAME="C.UTF-8"
LC_ADDRESS="C.UTF-8"
LC_TELEPHONE="C.UTF-8"
LC_MEASUREMENT="C.UTF-8"
LC_IDENTIFICATION="C.UTF-8"
LC_ALL=

现在进入mysql就可以输入中文了

mysql> 中文

参考:https://my.oschina.net/u/141159/blog/1786210