使用 docker-compose 部署 mysql
一、安装 docker-compose
安装教程:docker-Compose 安装与卸载_孟孟的博客-CSDN博客
二、mysql 的 docker-compose 文件
version: '3.1'
services:
mysql:
restart: always
image: mysql:5.7.22
container_name: mysql
ports:
- 3306:3306
environment:
TZ: Asia/Shanghai
MYSQL_ROOT_PASSWORD: 123456
command:
--character-set-server=utf8mb4
--collation-server=utf8mb4_general_ci
--explicit_defaults_for_timestamp=true
--lower_case_table_names=1
--max_allowed_packet=128M
--sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION,NO_ZERO_DATE,NO_ZERO_IN_DATE,ERROR_FOR_DIVISION_BY_ZERO"
volumes:
- /usr/local/docker/mysql/conf:/etc/mysql
- /usr/local/docker/mysql/logs:/var/log/mysql
- /usr/local/docker/mysql/data:/var/lib/mysql
docker命令:
docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=root -e TZ=Asia/Shanghai \
-v /home/docker/mysql/conf:/etc/mysql \
-v /home/docker/mysql/data:/var/lib/mysql \
-v /home/docker/mysql/logs:/var/log/mysql \
-d mysql:5.7.36 \
--character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci --default-time_zone='+8:00' --max_connections=1024
docker update mysql --restart=always
mysql8.0:
docker run \
--privileged=true \
--name mysql -p 23306:3306 -e MYSQL_ROOT_PASSWORD=Ioz@Meng -e TZ=Asia/Shanghai \
-v /home/docker/mysql/my.cnf:/etc/mysql/my.cnf \
-v /home/docker/mysql/conf.d:/etc/mysql/conf.d \
-v /home/docker/mysql/data:/var/lib/mysql \
-v /home/docker/mysql/log:/var/log/mysql \
-d mysql:8.0.28 \
--character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci --default-time_zone='+8:00' --max_connections=1024
创建my.cnf配置文件
touch /home/docker/mysql/my.cnf
my.cnf添加如下内容:
[mysqld]
user=mysql
character-set-server=utf8
default_authentication_plugin=mysql_native_password
secure_file_priv=/var/lib/mysql
expire_logs_days=7
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION
max_connections=1024
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8
PS:mysql5.7环境里,虽然可以设置default_authentication_plugin来改变认证加密方式,但是一般人不会去设置.在mysql8.0下,默认变成了default_authentication_plugin=caching_sha2_password,包括你刚初始化的root用户也是这个认证加密方式,这样的结果是让你除非用新的协议驱动,例如必须用8.0自带的mysql客户端才行,不然就连接不上数据库.这样就必然造成不兼容的情况。
Linux中连接MySQL出现“Access denied for user ‘root‘@‘localhost‘ (using password: NO)”_陈鱼落雁C的博客-CSDN博客
三、启动 mysql
到 docker-compose.yml 文件夹下,使用 docker-compose 相关命令:
1、前台运行
docker-compose up
2、后台运行
docker-compose up -d
3、启动
docker-compose start mysql
4、重启
docker-compose restart mysql
5、停止
docker-compose stop mysql
6、停止并移除容器
docker-compose down mysql