Docker安装Mysql（简易速通版）

Docker容器中安装Mysql

第一步 在docker中搜索Mysql并且拉取

---

docker search mysql			#搜索docker中的mysql

[root@hcss-ecs-768b ~]# docker search mysql
NAME                            DESCRIPTION                                     STARS     OFFICIAL
mysql                           MySQL is a widely used, open-source relation…   15116     [OK]
mariadb                         MariaDB Server is a high performing open sou…   5762      [OK]
percona                         Percona Server is a fork of the MySQL relati…   628       [OK]
phpmyadmin                      phpMyAdmin - A web interface for MySQL and M…   990       [OK]
circleci/mysql                  MySQL is a widely used, open-source relation…   30
bitnami/mysql                   Bitnami container image for MySQL               112
bitnami/mysqld-exporter         Bitnami container image for MySQL Server Exp…   7
cimg/mysql                                                                      3
ubuntu/mysql                    MySQL open source fast, stable, multi-thread…   62
rapidfort/mysql                 RapidFort optimized, hardened image for MySQL   25
bitnamicharts/mysql                                                             0
rapidfort/mysql8-ib             RapidFort optimized, hardened image for MySQ…   9
google/mysql                    MySQL server for Google Compute Engine          25
elestio/mysql                   Mysql, verified and packaged by Elestio         0
rapidfort/mysql-official        RapidFort optimized, hardened image for MySQ…   9
hashicorp/mysql-portworx-demo                                                   0
newrelic/mysql-plugin           New Relic Plugin for monitoring MySQL databa…   1
databack/mysql-backup           Back up mysql databases to... anywhere!         115
linuxserver/mysql               A Mysql container, brought to you by LinuxSe…   41
mirantis/mysql                                                                  0
linuxserver/mysql-workbench                                                     54
docksal/mysql                   MySQL service images for Docksal - https://d…   0
vitess/mysqlctld                vitess/mysqlctld                                1
drupalci/mysql-5.5              https://www.drupal.org/project/drupalci         3
eclipse/mysql                   Mysql 5.7, curl, rsync                          1
[root@hcss-ecs-768b ~]#

docker pull mysql:5.7 		#拉取stars最多的mysql，并且指定版本

#或者

docker pull mysql:lates		拉取最新的mysql

拉取完成后可以通过以下命令查看镜像

docker images 				#查看docker中的镜像

第二步 创建Mysql配置文件

mkdir -p /home/service/mysql/data 
mkdir -p /home/service/mysql/conf
cd /home/service/mysql/conf
touch my.cnf

将以下内容复制进去保存

[mysqld]
user=mysql
character-set-server=utf8
default_authentication_plugin=mysql_native_password
default-time_zone = '+8:00'
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

第三步 启动Mysql

启动Mysql容器

docker run -p 3306:3306 --name mysql -v /home/service/mysql/logs:/logs -v /home/service/mysql/data:/mysql_data -e MYSQL_ROOT_PASSWORD=123456 --restart=always -d mysql:5.7

-p 3306:3306：指定宿主机端口与容器端口映射关系
--name mysql：创建的容器名称
-v /home/service/mysql/logs:/logs：映射日志目录，宿主机:容器
-v /home/service/mysql/data:/mysql_data：映射数据目录，宿主机:容器
-e MYSQL_ROOT_PASSWORD=123456：指定mysql环境变量，root用户的密码为123456
--restart=always：总是跟随docker启动
-d mysql:5.7：后台运行mysql容器，版本是5.7。

第四步 进入Mysql并进行配置

docker exec -it mysql bash 								#通过执行docker exec -it mysql bash命令，您可以进入mysql容器，并在其中执行各种命令，例如查看文件、修改配置等
mysql -uroot -p											#登入Mysql
CREATE USER 'admin'@'%' IDENTIFIED BY '123456';			#创建用户
GRANT ALL ON *.* TO 'admin'@'%'; 						#给用户赋予权限
flush privileges; 										#刷新权限

总结

恭喜完成了mysql在docker中的配置和启动，接下来可以使用命令查看是否成功启用了mysql以及如何进入redis

docker ps -a  						#查看容器使用情况
docker stats mysql 					#查看mysql占用情况
docker exec -it redis /bin/bash		#进入容器的命令行
mysql -u root -p					#登入mysql
show databases;						#展示数据库
use databases;						#选择某个数据库

期望文章能对大家有所帮助~