docker之mysql安装配置

Docker之Mysql安装配置

1.Mysql镜像下载

docker pull mysql
docker images

2.启动mysql镜像并确定容器卷对应地址是否正确

whereis mysql

docker run -d -p 3306:3306 --privileged=true -v /app/mysql/log:/var/log/mysql -v /app/mysql/data:/var/lib/mysql -v /app/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 --name mysql 3218b38490ce

3.进入mysql，查看mysql容器编码

docker exec -it a370d43a3a62 /bin/bash

若发现如下图所示，需要进行编码修改

可进入容器内修改/etc/mysql/conf.d目录下或容器卷配置中/app/mysql/conf下my.cnf，内容如下

[client]
default_character_set=utf8
[mysqld]
collation_server = utf8_general_ci
character_set_server = utf8