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

Raabbit_Cunk

已于 2022-08-05 11:34:49 修改

阅读量1.2k

点赞数

分类专栏： docker 文章标签： mysql docker 数据库

于 2022-08-05 11:18:00 首次发布

本文链接：https://blog.csdn.net/weixin_45699541/article/details/126174128

版权

docker 专栏收录该内容

8 篇文章 0 订阅

订阅专栏

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)