docker mysql

创建数据存储目录

mkdir -p /srv/repo/mysql/

创建配置文件存储目录

mkdir -p /srv/conf/mysql/

创建配置文件处理字符编码

vim /srv/conf/mysql/my.cnf

输入以下内容

[client]
default-character-set = utf8mb4
[mysql]
default-character-set = utf8mb4
[mysqld]
character-set-client-handshake = FALSE
character-set-server = utf8mb4
collation-server = utf8mb4_unicode_ci

从官方镜像启动 mysql server

MySQL(5.7.19)的默认配置文件是 /etc/mysql/my.cnf 文件。如果想要自定义配置，建议向 /etc/mysql/conf.d 目录中创建 .cnf 文件。新建的文件可以任意起名，只要保证后缀名是 cnf 即可。新建的文件中的配置项可以覆盖 /etc/mysql/my.cnf 中的配置项。

docker run \
-d \
-p 3306:3306 \
-v /srv/repo/mysql:/var/lib/mysql \
-v /srv/conf/mysql:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=19b2ca8b28fbf7cc2c2cfe8daf2dd3a3 \
--name mysql \
--restart=always \
mysql/mysql-server:5.7

进入容器查看编码设置

show variables like 'char%';

+--------------------------+----------------------------+
| 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/ |
+--------------------------+----------------------------+

转载于:https://my.oschina.net/unfinalized/blog/1573305