环境部署2023-12-21 · 约 2 分钟
Linux/CentOS7中Docker安装MySQL8最新版本8.0.35
一、创建挂载目录
text
配置:conf
数据:data
日志:log
一、创建编辑my.cnf文件
提示
在conf目录下创建
conf
[client]
port = 3306
default-character-set = utf8mb4
[mysql]
port = 3306
default-character-set = utf8mb4
[mysqld]
# bind-address = 0.0.0.0
# port = 3306
max_connections=10000
character-set-server = utf8mb4
collation-server = utf8mb4_general_ci
# 设置时区和字符集
default-time-zone='+8:00'
character-set-client-handshake=FALSE
init_connect='SET NAMES utf8mb4 COLLATE utf8mb4_general_ci'
gtid-mode=ON
enforce-gtid-consistency = ON
三、运行
shell
docker run -e TZ=Asia/Shanghai \
--privileged=true \
--restart=always \
--name mysql \
-v /www/dk_project/projects/mysql/conf/my.cnf:/etc/mysql/my.cnf \
-v /www/dk_project/projects/mysql/data:/var/lib/mysql \
-v /www/dk_project/projects/mysql/log:/var/log \
-p 3306:3306 \
-e MYSQL_ROOT_PASSWORD=chen408817. \
-d mysql:8.0.35 \
提示
如果客户端连接不上:
- 注意开放防火墙
- 设置所有ip访问
觉得有用就点个赞吧