docker中安装MySQL5.7

1. 拉取镜像

[root@localhost ~]# docker pull mysql:5.7
5.7: Pulling from library/mysql
afb6ec6fdc1c: Pull complete                                                                                             0bdc5971ba40: Pull complete                                                                                             97ae94a2c729: Pull complete                                                                                             f777521d340e: Pull complete                                                                                             1393ff7fc871: Pull complete                                                                                             a499b89994d9: Pull complete                                                                                             7ebe8eefbafe: Pull complete                                                                                             4eec965ae405: Pull complete                                                                                             a531a782d709: Pull complete                                                                                             270aeddb45e3: Pull complete                                                                                             b25569b61008: Pull complete                                                                                             Digest: sha256:d16d9ef7a4ecb29efcd1ba46d5a82bda3c28bd18c0f1e3b86ba54816211e1ac4
Status: Downloaded newer image for mysql:5.7
docker.io/library/mysql:5.7

2. 启动镜像

[root@localhost ~]# docker run -p 3306:3306 --name mysql \
> -v /mydata/mysql/log:/var/log/mysql \
> -v /mydata/mysql/data:/var/data/mysql \
> -v /mydata/mysql/conf:/ect/mysql \
> -e MYSQL_ROOT_PASSWORD=root \
> -d mysql:5.7
bcdbd0e019fe193d6d0c2b91f184f1532d64111c250c30991f15c972d3fb99ac```

 3. 使用Navicat连接MySQL，测试是否连接成功

![连接成功](https://img-blog.csdnimg.cn/20200527150313230.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl8zOTU2MTc2Mg==,size_16,color_FFFFFF,t_70)


 4. 进入到MySQL容器

```bash
[root@localhost ~]# docker exec -it mysql /bin/bash
root@bcdbd0e019fe:/#

5. 查看mysql容器

root@bcdbd0e019fe:/# ls /
bin   dev                         ect            etc   lib    media  opt   root  sbin  sys  usr
boot  docker-entrypoint-initdb.d  entrypoint.sh  home  lib64  mnt    proc  run   srv   tmp  var

6. 添加my.cnf文件

vim /mydata/mysql/conf/my.cnf

[client]
default-character-set = utf8

[mysql]  
default-character-set = utf8

[mysqld]  
init_connect='SET collation_connection=utf8_unicode_ci'
init_connect='SET NAMES utf8'
character-set-server=utf8
collation_server=utf8_unicode_ci
skip-character-set-client-handshake
skip-name-resolve

:wq

7. 重启MySQL

[root@localhost conf]# docker restart mysql
mysql

8. 进入到docker中MySQL镜像查看是否有my.cnf文件生成

[root@localhost ~]# docker exec -it mysql /bin/bash
root@bcdbd0e019fe:/# cd /etc/mysql/
root@bcdbd0e019fe:/etc/mysql# ls
conf.d  my.cnf  my.cnf.fallback  mysql.cnf  mysql.conf.d

9. 至此，docker中安装MySQL就已经完成了。