docker安装mysql

 

此处采用pull的方式：这里我们拉取官方的镜像,标签为5.6

[root@localhost ~]# docker pull mysql:5.6
5.6: Pulling from library/mysql
743f2d6c1f65: Pull complete 
3f0c413ee255: Pull complete 
aef1ef8f1aac: Pull complete 
f9ee573e34cb: Pull complete 
3f237e01f153: Pull complete 
c834d5397c17: Pull complete 
167b4b0bb213: Pull complete 
8e13de731ad8: Pull complete 
0dcd497f8ff9: Pull complete 
82d36065c763: Pull complete 
f30363b0dfa6: Pull complete 
Digest: sha256:31b964a5d6a498fd7bae1c89e3c913b365c449f70706b075c65dbea405ff6db2
Status: Downloaded newer image for mysql:5.6

等待下载完成后，我们就可以在本地镜像列表里查到REPOSITORY为mysql,标签为5.6的镜像。

[root@localhost ~]# docker images |grep mysql
mysql               5.6                 73829d7b6139        4 weeks ago         256MB

使用mysql镜像运行容器

[root@localhost ~]# docker run -p 3306:3306 --name mysql -v $PWD/conf:/etc/mysql/conf.d -v $PWD/logs:/logs -v $PWD/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql:5.6
4c89fff9ac8c63b77801fec80cdef2677406d6c780728a81c45e494803076062

命令说明：

• -p 3306:3306：将容器的 33306 端口映射到主机的 3306 端口。

• -v -v $PWD/conf:/etc/mysql/conf.d：将主机当前目录下的 conf/my.cnf 挂载到容器的 /etc/mysql/my.cnf。

• -v $PWD/logs:/logs：将主机当前目录下的 logs 目录挂载到容器的 /logs。

• -v $PWD/data:/var/lib/mysql ：将主机当前目录下的data目录挂载到容器的 /var/lib/mysql 。

• -e MYSQL_ROOT_PASSWORD=123456：初始化 root 用户的密码。

• -d 后台启动

查看容器启动情况

[root@localhost ~]# docker ps 
CONTAINER ID        IMAGE               COMMAND                  CREATED              STATUS              PORTS                     NAMES
4c89fff9ac8c        mysql:5.6           "docker-entrypoint.s…"   About a minute ago   Up About a minute   0.0.0.0:33306->3306/tcp   mymysql

后台启动不会进入容器，如果想进入容器使用以下命令

[root@localhost ~]# docker exec -it 4c89fff9ac8c bash
root@4c89fff9ac8c:/#

进入容器之后可以使用命令行操作容器了

root@4c89fff9ac8c:/# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 4
Server version: 5.6.44 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> show database;

 退出容器命令：

root@4c89fff9ac8c:/# exit
exit
There are stopped jobs.
root@4c89fff9ac8c:/# exit;
exit
Terminal close -- exit!
Aborted
[root@localhost ~]#

停止容器命令

[root@localhost ~]# docker stop mymysql 
mymysql
[root@localhost ~]# 

启动容器命令

[root@localhost ~]# docker start mymysql 
mymysql
[root@localhost ~]#

docker部署rebbitmq地址：https://www.jianshu.com/p/14ffe0f3db94