Centos基础环境--docker安装mysql8.0

环境

1、Centos 8.0 2、docker版本17.12.1-ce 3、mysql 8.0

拉取镜像

代码语言：javascript复制

[root@iZuf68t6hada0ayijajs45Z docker]# docker pull mysql:8.0
8.0: Pulling from library/mysql
6ec8c9369e08: Pull complete 
177e5de89054: Pull complete 
ab6ccb86eb40: Pull complete 
e1ee78841235: Pull complete 
09cd86ccee56: Pull complete 
78bea0594a44: Pull complete 
caf5f529ae89: Pull complete 
cf0fc09f046d: Pull complete 
4ccd5b05a8f6: Pull complete 
76d29d8de5d4: Pull complete 
8077a91f5d16: Pull complete 
922753e827ec: Pull complete 
Digest: sha256:fb6a6a26111ba75f9e8487db639bc5721d4431beba4cd668a4e922b8f8b14acc
Status: Downloaded newer image for mysql:8.0

使用docker images可以查看已获取的镜像

代码语言：javascript复制

[root@iZuf68t6hada0ayijajs45Z docker]# docker images
REPOSITORY          TAG                 IMAGE ID            CREATED             SIZE
mysql               8.0                 e3fcc9e1cc04        5 hours ago         544MB

启动

代码语言：javascript复制

[root@iZuf68t6hada0ayijajs45Z svdb]# docker run --name mysql --restart=always 
>     -v /data/svdb/mysql/conf/my.cnf:/etc/mysql/my.cnf 
>     -v /data/svdb/mysql/data:/var/lib/mysql 
>     -p 3317:3306 
>     -e MYSQL_ROOT_PASSWORD="root" 
>     -e TZ=Asia/Shanghai 
>     -d mysql:8.0 --lower-case-table-names=1

1、-name mysql ：给Mysql容器起一个别名 2、-restart=always：开机启动 3、-v：将容器的文件挂载到宿主目录，避免以后在卸载docker的时候，数据丢失。如：-v /data/svdb/mysql/conf/my.cnf:/etc/mysql/my.cnf 是将容器的/etc/mysql/my.cnf 挂载到主机的/data/svdb/mysql/conf/my.cnf 4、-e MYSQL_ROOT_PASSWORD：设置密码 5、-p 3317:3306：mysql端口映射到主机的3317端口 6、-d mysql:8.0：后台运行容器 7、–lower-case-table-names=1一定要加，mysql8.0关方规定只有在初始化的时候给与配置，后续不管在my.cnf还是重新docker run --lower都无效（重新docker run --lower必须保证/var/lib/mysql仓库是干净的才可以，不然出错）

进入Mysql

先进入mysql镜像，在登入mysql.

代码语言：javascript复制

[root@iZuf68t6hada0ayijajs45Z svdb]# docker exec -it mysql /bin/bash
root@f2c3eb8f47c2:/# 
root@f2c3eb8f47c2:/# mysql -u root -p
Enter password: 
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 9
Server version: 8.0.21 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>

查看mysql信息

代码语言：javascript复制

[root@iZuf68t6hada0ayijajs45Z ~]# docker inspect mysql

完事。

centos 容器 mysql 基础镜像

0 人点赞