docker安装mysql

1.拉取镜像

docker pull mysql:8.0

2.创建数据目录和配置文件

本地

mkdir /home/jmlib/docker-v/mysql8/data

mkdir /home/jmlib/docker-v/mysql8/cnf

3.创建配置文件

本地

vim /home/jmlib/docker-v/mysql8/data/my.cnf

服务

vim /home/jmlib/docker-v/mysql8/data/my.cnf

配置详情

[client]

default-character-set = utf8mb4

[mysqld]

datadir = /usr/mysql/data

character_set_server = utf8mb4

collation_server = utf8mb4_bin

secure-file-priv= NULL

symbolic-links=0

!includedir /etc/mysql/conf.d/

4.启动容器

本地

docker run -d  -p 3306:3306 \
-v /home/jmlib/docker-v/mysql8/data/my.cnf:/etc/mysql/my.cnf \
--restart=unless-stopped \
-e MYSQL_ROOT_PASSWORD=123456 \
--name mysql mysql:8.0

服务

docker run -d  -p 3306:3306 \
-v /home/jmlib/docker-v/mysql8/cnf/my.cnf:/etc/mysql/conf.d/my.cnf \
-v /home/jmlib/docker-v/mysql8/data:/var/lib/mysql \
-v /home/jmlib/docker-v/mysql8/home:/home \
--restart=always \
-e MYSQL_ROOT_PASSWORD=123456 \
--name mysql mysql:8.0

5.mysql初始化

初始化详情

docker exec -it mysql bash
mysql -uroot -p
use mysql
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'yiluxiangbei';
flush privileges;