更改docker里mysql的字符编码

朱雀 2022-10-17 04:28 236阅读 0赞

**目录**

更改Linux里mysql的字符编码

1.进入MySQL容器

2.进入到目录/etc/mysql

3.下载vim

4.编辑mysql.conf/my.cnf/conf.d/mysql.conf.d

5.保存，退出容器并重启msyql

6.进入容器，登录mysql，查看字符编码

--------------------

## 更改Linux里mysql的字符编码 ##

### 1.进入MySQL容器 ###

*  docker exec -it mysql bash

### 2.进入到目录/etc/mysql ###

*  cd /etc/mysql

### 3.下载vim ###

*  apt-get install vim

**下载失败,先更新后下载**

*  apt-get update

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70][]

### 4.编辑mysql.conf/my.cnf/conf.d/mysql.conf.d ###

*  vim mysql.conf/my.cnf/conf.d/mysql.conf.d

> \[client\]  
> default-character-set=utf8  
>   
> \[mysqld\]  
> default-storage-engine=INNODB  
> character-set-server=utf8  
> collation-server=utf8\_general\_ci

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 1][]

### 5.保存，退出容器并重启msyql ###

*  exit
 *  docker restart mysql

![2021060316470595.png][]

### 6.进入容器，登录mysql，查看字符编码 ###

*  docker exec -it mysql bash
 *  mysql -u root -p密码
 *  SHOW VARIABLES LIKE '%character%';

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 2][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 3][]

在数据库中同样可以看到效果

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 4][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70]: /images/20221014/28e4c9bb88e24dbc9abf82ef853df1dc.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 1]: /images/20221014/43274c23ae3e4d9b8b73df8aa7757f6b.png
[2021060316470595.png]: /images/20221014/d23286b18f414a27a3a2ac6cb828c96b.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 2]: /images/20221014/9ec68be17603464bb9862b61bed0deed.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 3]: /images/20221014/7bf6c47632f84178a699518743e9f645.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3F3cTE1MTgzNDY4NjQ_size_16_color_FFFFFF_t_70 4]: /images/20221014/a57d978b86b34325864e16a022cf4163.png