docker（四）docker——mysql 8解决中文乱码，设置utf-8

docker 容器mysql 控制台默认不能输入中文 ， 控制台插入有中文的数据是空的无效！！！

先上配置文件

[mysql] 
default-character-set = utf8 

[mysql.server] 
default-character-set = utf8

[mysqld_safe] 
default-character-set = utf8  

[client]
default-character-set = utf8

[mysqld] 
character_set_server = utf8 
init_connect='SET NAMES utf8'

进入 bush控制台查看字符集


[root@VM-4-14-centos conf]# docker restart mysql
mysql
[root@VM-4-14-centos conf]# docker exec -it 87a33f3096fd bash

mysql -uroot -p


mysql> SHOW VARIABLES LIKE 'character%';
+--------------------------+--------------------------------+
| Variable_name            | Value                          |
+--------------------------+--------------------------------+
| character_set_client     | utf8mb3                        |
| character_set_connection | utf8mb3                        |
| character_set_database   | utf8mb3                        |
| character_set_filesystem | binary                         |
| character_set_results    | utf8mb3                        |
| character_set_server     | utf8mb3                        |
| character_set_system     | utf8mb3                        |
| character_sets_dir       | /usr/share/mysql-8.0/charsets/ |
+--------------------------+--------------------------------+
8 rows in set (0.01 sec)