docker 安装 mysql5.7 就是这么简单？

docker 如何安装 mysql？

# 先拉取镜像
sudo docker pull mysql:5.7
# 创建挂载目录
mkdir -p /home/docker/mysql/conf
mkdir -p /home/docker/mysql/logs
mkdir -p /home/docker/mysql/data
# 启动
docker run --restart=always -p 3306:3306 --name mysql -v /home/docker/mysql/conf:/etc/mysql/conf.d -v /home/docker/mysql/logs:/var/log/mysql -v /home/docker/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD='123456' -d mysql:5.7

mysql相关配置

# 进入conf的目录
cd /home/docker/mysql/conf

# 编辑配置文件，因为做了挂载，所以日志的路径是不需要更改的
vi mysqld.cnf

[mysqld]
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
datadir         = /var/lib/mysql
# By default we only accept connections from localhost
#bind-address   = 127.0.0.1
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0

log-error=/var/log/mysql/error.log
slow_query_log=ON
slow_query_log_file=/var/log/mysql/slowquery.log
long_query_time=3
log-queries-not-using-indexes=ON
lower_case_table_names=1
character-set-server=utf8mb4
default-time-zone = '+08:00'
# 开启binlog
log-bin = /var/lib/mysql/mysql-bin.log
expire-logs-days = 14
max-binlog-size = 500M
server-id = 1

[client]
default-character-set=utf8mb4
[mysql]
default-character-set=utf8mb4

再重启一遍mysql，或者你先把文件创建好，再运行第一步，就不需要重启啦

docker restart mysql

然后在挂载的目录下就可以看到mysql的数据文件以及日志文件