美文网首页
docker 安装mysql

docker 安装mysql

作者: maxZhang | 来源:发表于2018-07-01 10:19 被阅读99次

1.查看所有的dcker hub上的mysql镜像 docker search mysql

MacBook:mysql_docker max$ docker search mysql
NAME                                                   DESCRIPTION                                     STARS               OFFICIAL            AUTOMATED
mysql                                                  MySQL is a widely used, open-source relation…   6465                [OK]                
mariadb                                                MariaDB is a community-developed fork of MyS…   2034                [OK]                
mysql/mysql-server                                     Optimized MySQL Server Docker images. Create…   471                                     [OK]
percona                                                Percona Server is a fork of the MySQL relati…   344                 [OK]                
zabbix/zabbix-server-mysql                             Zabbix Server with MySQL database support       106                                     [OK]
hypriot/rpi-mysql                                      RPi-compatible Docker Image with Mysql          88                                      
centurylink/mysql                                      Image containing mysql. Optimized to be link…   60                                      [OK]
zabbix/zabbix-web-nginx-mysql                          Zabbix frontend based on Nginx web-server wi…   57                                      [OK]
1and1internet/ubuntu-16-nginx-php-phpmyadmin-mysql-5   ubuntu-16-nginx-php-phpmyadmin-mysql-5          36                                      [OK]
tutum/mysql                                            Base docker image to run a MySQL database se…   32                                      
centos/mysql-57-centos7                                MySQL 5.7 SQL database server                   31                                      
mysql/mysql-cluster                                    Experimental MySQL Cluster Docker images. Cr…   30                                      
schickling/mysql-backup-s3                             Backup MySQL to S3 (supports periodic backup…   20                                      [OK]
zabbix/zabbix-proxy-mysql                              Zabbix proxy with MySQL database support        15                                      [OK]
bitnami/mysql                                          Bitnami MySQL Docker Image                      15                                      [OK]
linuxserver/mysql                                      A Mysql container, brought to you by LinuxSe…   14                                      
centos/mysql-56-centos7                                MySQL 5.6 SQL database server                   8                                       
openshift/mysql-55-centos7                             DEPRECATED: A Centos7 based MySQL v5.5 image…   6                                       
circleci/mysql                                         MySQL is a widely used, open-source relation…   5                                       
dsteinkopf/backup-all-mysql                            backup all DBs in a mysql server                4                                       [OK]
mysql/mysql-router                                     MySQL Router provides transparent routing be…   2                                       
openzipkin/zipkin-mysql                                Mirror of https://quay.io/repository/openzip…   1                                       
cloudfoundry/cf-mysql-ci                               Image used in CI of cf-mysql-release            0                                       
cloudposse/mysql                                       Improved `mysql` service with support for `m…   0                                       [OK]
ansibleplaybookbundle/mysql-apb                        An APB which deploys RHSCL MySQL                0                                       [OK]

2.选择需要拉取的镜像docker pull mysql,会默认拉取tag为latest的mysql官方镜像

latest: Pulling from library/mysql
683abbb4ea60: Pull complete 
0550d17aeefa: Pull complete 
7e26605ddd77: Pull complete 
9882737bd15f: Pull complete 
999c06ab75f6: Pull complete 
c71d695f9937: Pull complete 
c38f847c1491: Pull complete 
5e0cb05a8fc3: Pull complete 
c89e3e373fca: Pull complete 
fa39a2c9922d: Pull complete 
b293d9c897c4: Pull complete 
3dc061869740: Pull complete 
Digest: sha256:43ed4f8c9d1695e97a39cdfe9475af9096e3723cfb79d820d8da00d61a277a85
Status: Downloaded newer image for mysql:latest

3.新建本地映射到docker镜像的mysql文件目录,/mysql/conf、/mysql/logs、/mysql/data。完毕后使用

docker run -p 3306:3306 --name mymysql -v $PWD/conf:/etc/mysql/conf.d -v $PWD/logs:/logs -v $PWD/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql

4.完成后,使用docker ps即可查看正在运行的容器

MacBook:mysql max$ docker ps
CONTAINER ID        IMAGE               COMMAND                  CREATED             STATUS              PORTS                    NAMES
b158184523be        mysql               "docker-entrypoint.s…"   13 seconds ago      Up 26 seconds       0.0.0.0:3306->3306/tcp   mymysql

5.进入docker 内部

MacBook:mysql max$ docker exec -it b158184523be bash
root@b158184523be:/# mysql -uroot -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8
Server version: 8.0.11 MySQL Community Server - GPL

Copyright (c) 2000, 2018, 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> 

相关文章

网友评论

      本文标题:docker 安装mysql

      本文链接:https://www.haomeiwen.com/subject/ikjcuftx.html