Docker下安装MySQL

如果在Doc k e r下直接拉取MySQL并运行镜像，由于没有指定字符编码集，可能会存在插入中文出现乱码的情况，并且当容器删除后，容器里面存在的数据会丢失，所以在运行容器时应该使用数据卷进行挂载，按照如下步骤操作即可。

Doc k e r下安装MySQL

启动Doc k e r后实现数据卷挂载，将mysql相关的运行数据同步到宿主机的指定目录

[root@localhost conf]# docker run -d -p 3307:3306 --privileged=true -v /opt/mysql/log:/var/log/mysql -v /opt/mysql/data:/var/lib/mysql -v /opt/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 --name mysql01 mysql:5.7
cce55233a5f2719e0d447c83df29bcd65c897a5fb9ced714cdfc7d836aa3319e

创建 my.cnf文件

[root@localhost ~]#  cd /opt/mysql/conf/
[root@localhost conf]# vim my.cnf

编辑 my.cnf 文件来避免乱码问题

[client]
default_character_set=utf8
[mysqld]
collation_server = utf8_general_ci
character_set_server = utf8

由于修改了配置需要重新启动mysql 容器

[root@localhost conf]# docker restart cce55233a5f2
cce55233a5f2

进入容器并登录mysql 数据库

[root@localhost conf]# docker exec -it cce55233a5f2 /bin/bash
root@cce55233a5f2:/# mysql -u root -p
mysql&gt;

查看编码集

mysql&gt; show variables like 'character%';
+--------------------------+----------------------------+
| Variable_name            | Value                      |
+--------------------------+----------------------------+
| character_set_client     | utf8                       |
| character_set_connection | utf8                       |
| character_set_database   | utf8                       |
| character_set_filesystem | binary                     |
| character_set_results    | utf8                       |
| character_set_server     | utf8                       |
| character_set_system     | utf8                       |
| character_sets_dir       | /usr/share/mysql/charsets/ |
+--------------------------+----------------------------+
8 rows in set (0.01 sec)