docker部署mysql5.7

一、安装docker

yum install -y yum-utils device-mapper-persistent-data lvm2
yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo
yum install -y docker-ce-18.06.1.ce-3.el7
systemctl start docker
systemctl enable docker

二、部署docker-compose

curl -L "https://github.com/docker/compose/releases/download/1.24.0/docker-compose-$(uname -s)-$(uname -m)" -o /usr/local/bin/docker-compose
chmod +x /usr/local/bin/docker-compose

三、部署mysql

1、部署的是mysql5.7的镜像

docker pull mysql:5.7

2.创建一个配置文件的目录

mkdir /data/docker/docker-dir/mysql/conf -p

3.修改配置文件内容

vim /data/docker/docker-dir/mysql/conf/my.cnf
    [mysql] default-character-set=utf8mb4 
    [mysqld] character_set_server=utf8mb4 
    init_connect='SET NAMES utf8' 
    lower_case_table_names = 1   

4.启动容器

docker run --name mysql -p 3306:3306 -v /data/docker/docker-dir/mysql/conf:/etc/mysql/conf.d -v /data/docker/docker-dir/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=DLEqlKsuFyUKfisY -d mysql:5.7

5.进入容器内部

docker exec -it mysql /bin/bash

6.登录进mysql

 mysql -uroot -pDLEqlKsuFyUKfisY

7.修改mysql可以从远程访问（进入sql环境下执行）

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'DLEqlKsuFyUKfisY' WITH  GRANT OPTION;
 FLUSH  PRIVILEGES;