centos8 docker部署mysql

关于docker

docker是容器化部署的技术方案，主要作用可以理解为以较小的机器资源代价，快速构建生产部署所需要的环境，docker构建的容器本质上是一个进程，具体见官网介绍：https://www.docker.com/

具体部署过程

1、确保docker已安装在centos8上

[root@iZwz9ir35kqtndn7ojffvpZ mysql]# docker -v
Docker version 20.10.8, build 3967b7d

2、直接拉取mysql最新版本安装

[root@iZwz9ir35kqtndn7ojffvpZ mysql]# docker pull mysql:latest

3、安装完发现会有一个新的镜像，见下

[root@iZwz9ir35kqtndn7ojffvpZ mysql]# docker images
REPOSITORY   TAG       IMAGE ID       CREATED        SIZE
mysql        latest    c60d96bd2b77   3 weeks ago    514MB

4、使用指定镜像启动容器

docker run -itd --name mysql-test -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 mysql

5、启动完查看容器情况

[root@iZwz9ir35kqtndn7ojffvpZ mysql]# docker ps -a
CONTAINER ID   IMAGE           COMMAND                  CREATED          STATUS          PORTS                                                  NAMES
0f573be36429   mysql           "docker-entrypoint.s…"   24 minutes ago   Up 24 minutes   0.0.0.0:3306->3306/tcp, :::3306->3306/tcp, 33060/tcp   mysql-test

6、使用mysql -h 127.0.0.1 -u root -p进入mysql命令行模式
备注：注意这里不要直接用mysql -uroot -p否则登陆不进去

[root@iZwz9ir35kqtndn7ojffvpZ mysql]# mysql -h 127.0.0.1 -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 16
Server version: 8.0.26 MySQL Community Server - GPL

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

7、此时只能本机进入mysql，为便于远程也能连接，需要授权远程连接

mysql> ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
Query OK, 0 rows affected (0.01 sec)

8、远程连接试验，这里的ip是docker部署mysql对应的centos的ip地址，见下是连接成功的界面：