docker部署mysql时遇到的问题

sudo docker pull mysql:5.7

# --name指定容器名字 -v目录挂载 -p指定端口映射  -e设置mysql参数 -d后台运行
sudo docker run -p 3306:3306 --name mysql \
-v /mydata/mysql/log:/var/log/mysql \
-v /mydata/mysql/data:/var/lib/mysql \
-v /mydata/mysql/conf:/etc/mysql \
-e MYSQL_ROOT_PASSWORD=root \
-d mysql:5.7
[root@localhost ~]# docker ps
CONTAINER ID   IMAGE       COMMAND                  CREATED         STATUS          PORTS                                                  NAMES
459956af3cc0   mysql:5.7   "docker-entrypoint.s…"   4 minutes ago   Up 11 seconds   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   mysql

一开始在Docker run这里疯狂报错，

docker: Error response from daemon: driver failed programming external connectivity on endpoint mysql (92c51f553f2faa80f0ae36bb03786ce9a42ffedc0967eb64653d83d801ae1924):  (iptables failed: iptables --wait -t nat -A DOCKER -p tcp -d 0/0 --dport 3306 -j DNAT --to-destination 172.17.0.2:3306 ! -i docker0: iptables: No chain/target/match by that name.

大概意思就是端口报错，端口被占用，然后查看端口进程发现Mysql一直占用着3306端口。

这里就卡了两个小时才想明白这里的mysql是外部的Mysql不是Docker容器里的mysql，所以要将这里的mysql进程关闭，然后查看Ps  -a 找到Mysql，在docker start myql 启动容器里mysql，这时在docker ps下，才有mysql进程