.NET 云原生架构师训练营（模块二 基础巩固 MySQL环境准备）--学习笔记

[root@VM-0-13-centos docker]# cd /etc/docker

[root@VM-0-13-centos docker]# cat daemon.json
{
    "registry-mirrors": ["https://eijm45od.mirror.aliyuncs.com"]
}

[root@VM-0-13-centos docker]# systemctl restart docker

docker run \
--detach \
--name=mysql02 \
--env="MYSQL_ROOT_PASSWORD=root123456@" \
--publish 7306:3306 \
--volume=/root/docker/mysql02/conf.d:/etc/mysql/conf.d \
--volume=/root/docker/mysql02/data:/var/lib/mysql \
mysql/mysql-server:latest \
--character-set-server=utf8 \
--collation-server=utf8_general_ci 

docker ps

CONTAINER ID        IMAGE                       COMMAND                  CREATED             STATUS                 PORTS                                     NAMES
4c99fcf57b71        mysql/mysql-server:latest   "/entrypoint.sh --ch…"   3 weeks ago         Up 3 weeks (healthy)   33060-33061/tcp, 0.0.0.0:7306->3306/tcp   mysql02

[root@VM-0-13-centos ~]# docker exec -it mysql02 mysql -uroot -p

mysql> use mysql;

mysql> update user set host='%' where user='root';

mysql> flush privileges;