1. docker 安装mysql8
docker run \
-p 3307:3306 \
--name mysql \
--privileged=true \
--restart unless-stopped \
-v /home/fk/mysql8/mysql:/etc/mysql \
-v /home/fk/mysql8/conf.d:/etc/mysql/conf.d \
-v /home/fk/mysql8/logs:/logs \
-v /home/fk/mysql8/data:/var/lib/mysql \
-v /home/fk/mysql8/mysql-files:/var/lib/mysql-files \
-v /etc/localtime:/etc/localtime \
-e MYSQL_ROOT_PASSWORD=123456 \
-d mysql:8.0.21 \
--lower-case-table-names=1
参数说明:
| 变量 | 含义 |
|---|---|
| lower-case-table-names | 1:忽略表名大小写；0:不忽略大小写 |
| MYSQL_ROOT_PASSWORD | 密码123456 |
