安装Docker
1、 Docker 教程地址:[https://www.runoob.com/docker/centos-docker.install.html]
2、安装docker
命令:yum install docker-io
在这里插入图片描述
3、启动docker
命令:service docker start
4、查看docker是否启动成功
命令:ps -ef|grep docker
使用docker安装mysql
1、查询mysql
命令:docker search mysql
[root@izuf66sz7dk0i1gx4bq55pz ~]# docker search mysql
INDEX NAME DESCRIPTION STARS OFFICIAL AUTOMATED
docker.io docker.io/mysql MySQL is a widely used, open-source relati... 11653 [OK]
docker.io docker.io/mariadb MariaDB Server is a high performing open s... 4436 [OK]
docker.io docker.io/mysql/mysql-server Optimized MySQL Server Docker images. Crea... 865 [OK]
docker.io docker.io/centos/mysql-57-centos7 MySQL 5.7 SQL database server 91
docker.io docker.io/mysql/mysql-cluster Experimental MySQL Cluster Docker images. ... 89
docker.io docker.io/centurylink/mysql Image containing mysql. Optimized to be li... 59 [OK]
docker.io docker.io/databack/mysql-backup Back up mysql databases to... anywhere! 52
docker.io docker.io/prom/mysqld-exporter 43 [OK]
docker.io docker.io/deitch/mysql-backup REPLACED! Please use http://hub.docker.com... 41 [OK]
docker.io docker.io/tutum/mysql Base docker image to run a MySQL database ... 35
docker.io docker.io/linuxserver/mysql A Mysql container, brought to you by Linux... 33
docker.io docker.io/schickling/mysql-backup-s3 Backup MySQL to S3 (supports periodic back... 31 [OK]
docker.io docker.io/mysql/mysql-router MySQL Router provides transparent routing ... 23
docker.io docker.io/centos/mysql-56-centos7 MySQL 5.6 SQL database server 20
docker.io docker.io/arey/mysql-client Run a MySQL client from a docker container 19 [OK]
docker.io docker.io/fradelg/mysql-cron-backup MySQL/MariaDB database backup using cron t... 16 [OK]
docker.io docker.io/yloeffler/mysql-backup This image runs mysqldump to backup data u... 7 [OK]
docker.io docker.io/openshift/mysql-55-centos7 DEPRECATED: A Centos7 based MySQL v5.5 ima... 6
docker.io docker.io/ansibleplaybookbundle/mysql-apb An APB which deploys RHSCL MySQL 3 [OK]
docker.io docker.io/devilbox/mysql Retagged MySQL, MariaDB and PerconaDB offi... 3
docker.io docker.io/idoall/mysql MySQL is a widely used, open-source relati... 3 [OK]
docker.io docker.io/jelastic/mysql An image of the MySQL database server main... 2
docker.io docker.io/centos/mysql-80-centos7 MySQL 8.0 SQL database server 1
docker.io docker.io/widdpim/mysql-client Dockerized MySQL Client (5.7) including Cu... 1 [OK]
docker.io docker.io/monasca/mysql-init A minimal decoupled init container for mysql 0
[root@izuf66sz7dk0i1gx4bq55pz ~]#
2、安装mysql
命令:docker pull mysql:5.7
3、查看镜像
命令:docker images
4.启动mysql容器
命令:
docker run -itd --name mysql-test -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql:5.7
[root@izuf66sz7dk0i1gx4bq55pz ~]# docker run -itd --name mysql-test -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql:5.7
//成功后就会生产下面的值。
a1a08aa0b6b31c4678c5f41f499fef174e606441cd58270a5661ece3f1e7ba54
5.可以执行var/lib/docker/containers/下查看容器
命令:
cd /var/lib/docker/containers/
[root@izuf66sz7dk0i1gx4bq55pz ~]# cd /var/lib/docker/containers/
[root@izuf66sz7dk0i1gx4bq55pz containers]# ls
a1a08aa0b6b31c4678c5f41f499fef174e606441cd58270a5661ece3f1e7ba54
[root@izuf66sz7dk0i1gx4bq55pz containers]#
6、查看mysql进程
命令:
docker ps -a
[root@izuf66sz7dk0i1gx4bq55pz ~]# docker ps -a
CONTAINER ID IMAGE COMMAND CREATED STATUS PORTS NAMES
befe1a3bce96 mysql "docker-entrypoint..." About a minute ago Up About a minute 0.0.0.0:3306->3306/tcp, 33060/tcp mysql-test
[root@izuf66sz7dk0i1gx4bq55pz ~]# docker rm -f befe1a3bce96
7、进入mysql容器,并登陆mysql
命令:
docker exec -it mysqlserver bash
命令:
mysql -uroot -p
8、开启远程访问权限
命令:
use mysql;
命令:
select host,user from user;
命令:
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
命令:
flush privileges;
镜像里面 root用户已经有远程连接权限在里面,所以不需要去设置,只是模式不一样才导致无法连接,把root用户的密码改成 mysql_native_password 模式,即可远程连接
查看docker日志
命令:docker logs -f --tail 10 a4dac74d48f7
常用命令
查看进程
命令:docker ps -a
关闭docker中mysql容器
命令:docker stop mysqlserver
重启docker中mysql重启
重启docker
命令:systemctl restart docker
关闭docker
命令:systemctl stop docker
参考于:
知识追求者
RNUOOB.COM