Dokcer 安装mysql

1、拉取镜像

sudo docker pull mysql:8.0

2、创建数据目录

sudo mkdir -p /home/dockerdata/mysql/{conf,data,log}

3、新增写入权限

sudo chmod 777 /home/dockerdata/mysql/{conf,data,log}

4、创建配置文件

cd /home/dockerdata/mysql/conf/
vi my.cnf

[client]
default-character-set=utf8mb4

[mysql]
default-character-set=utf8mb4

[mysqld]
#取消 group 严格模式

sql-mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

character-set-server=utf8mb4

bind-address =0.0.0.0

5、创建容器sudo docker run -d \

-e MYSQL_ROOT_PASSWORD=123456 \
-e TZ=Asia/Shanghai \

-v /home/dockerdata/mysql/conf/my.cnf:/etc/mysql/my.cnf \
-v /home/dockerdata/mysql/logs:/logs \
-v /home/dockerdata/mysql/mysql:/var/lib/mysql \
-p 3306:3306  \
--name mysql \
--restart always \
mysql:8.0 --lower-case-table-names=1 --sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"

6、进入容器

sudo docker exec -it mysql bash

7、进入mysql

mysql -uroot -p

8、修改root用户

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'your_password';
FLUSH PRIVILEGES;

9、重启容器

sudo docker restart mysql