Docker 安装 MySQL5.7

查找 MySQL 版本

plaintext

❯ docker search mysql
NAME                             DESCRIPTION                                     STARS     OFFICIAL   AUTOMATED
mysql/mysql-server               Optimized MySQL Server Docker images. Create…   905                  [OK]
mysql/mysql-cluster              Experimental MySQL Cluster Docker images. Cr…   92                   
centos/mysql-57-centos7          MySQL 5.7 SQL database server                   92                   
bitnami/mysql                    Bitnami MySQL Docker Image                      65                   [OK]
databack/mysql-backup            Back up mysql databases to... anywhere!         55                   
circleci/mysql                   MySQL is a widely used, open-source relation…   24                   
mysql/mysql-router               MySQL Router provides transparent routing be…   23                   
ubuntu/mysql                     MySQL open source fast, stable, multi-thread…   22                   
centos/mysql-56-centos7          MySQL 5.6 SQL database server                   21                   
google/mysql                     MySQL server for Google Compute Engine          19                   [OK]
mysqlboy/docker-mydumper         docker-mydumper containerizes MySQL logical …   3                    
mysqlboy/mydumper                mydumper for mysql logcial backups              3                    
ibmcom/mysql-s390x               Docker image for mysql-s390x                    1                    
bitnami/mysqld-exporter                                                          1                    
mysql                            MySQL is a widely used, open-source relation…   0         [OK]       
ibmcom/tidb-ppc64le              TiDB is a distributed NewSQL database compat…   0                    
mysql/mysql-operator             MySQL Operator for Kubernetes                   0                    
mirantis/mysql                                                                   0                    
cimg/mysql                                                                       0                    
mysqlboy/elasticsearch                                                           0                    
mysqleatmydata/mysql-eatmydata                                                   0                    
phpmyadmin                       phpMyAdmin - A web interface for MySQL and M…   0         [OK]       
percona                          Percona Server is a fork of the MySQL relati…   0         [OK]       
mariadb                          MariaDB Server is a high performing open sou…   0         [OK]       
mysqled25519/mysqled25519

拉取下载镜像

plaintext

docker pull mysql-server:5.7

查看下载的镜像

plaintext

❯ docker images |grep mysql
mysql/mysql-server   5.7       b3eaae317eb2   3 weeks ago   390MB

创建容器

plaintext

docker run --name mysql -e MYSQL_USER=vapor  -e MYSQL_PASSWORD=vapor -e MYSQL_DATABASE=vapor -e MYSQL_ROOT_PASSWORD=vapor  -p 3306:3306 -d mysql/mysql-server:5.7

启动mysql

plaintext

docker exec -it mysql bash

mysql -u root -p

use mysql;

//授权vapor可以远程登录
GRANT ALL PRIVILEGES ON *.* TO 'vapor'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

FLUSH PRIVILEGES;