mysql docker字符集配置_docker中mysql的字符编码设置

默认的字符编码是 瑞典latin1

字符编码设置

首先要安装文本编辑器 vim

//更新关联(更新软件包列表)

apt-get updata

如果出现 Invalid operation upgrade

//更新软件包列表并且更新所有已安装的软件包

sudo apt update && sudo apt full-upgrade

//安装vim

apt-get install vim

安装好vim后

// 安装好vim后，跳转到mysql容器自动生成的配置文件目录下

cd /etc/mysql

// 打开配置文件my.cnf

vim my.cnf

// 在文件末尾添加以下字段，此时我默认编码格式为utf8，如果用GBK自己改即可

[mysql]

default-character-set=utf8mb4

[mysqld]

character_set_server=utf8mb4

init_connect='SET NAMES utf8'

lower_case_table_names = 1// 保存配置文件，并使用exit命令退出mysql容器

重启mysql

docker restart mysql

查看配置是否生效

//进入mysql容器

[root@localhost /]# docker exec -it 8429d2f3f2a6 /bin/bash

//登录mysql客户端

root@8429d2f3f2a6:/# mysql -u root -p 123456

//输入以下两条命令

mysql> show variables like 'character_set%';

+--------------------------+----------------------------+

| Variable_name | Value |

+--------------------------+----------------------------+

| character_set_client | utf8mb4 |

| character_set_connection | utf8mb4 |

| character_set_database | utf8mb4 |

| character_set_filesystem | binary |

| character_set_results | utf8mb4 |

| character_set_server | utf8mb4 |

| character_set_system | utf8 |

| character_sets_dir | /usr/share/mysql/charsets/ |

+--------------------------+----------------------------+

8 rows in set (0.02 sec)

mysql> show variables like 'collation%';

+----------------------+--------------------+

| Variable_name | Value |

+----------------------+--------------------+

| collation_connection | utf8mb4_general_ci |

| collation_database | utf8mb4_general_ci |

| collation_server | utf8mb4_general_ci |

+----------------------+--------------------+

3 rows in set (0.00 sec)

mysql>