docker安装Mysql

官方镜像 https://hub.docker.com/_/mysql

mysql8

docker run

  docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-secret-pw -d mysql:tag
  # 或指定加密方式
  docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=my-pw -d mysql:tag --default-authentication-plugin=mysql_native_password

docker run --name some-mysql -e MYSQL_ROOT_PASSWORD=加密后密码 mysql:8.0.17
#不开放端口
docker run --name mysql8 -e MYSQL_ROOT_PASSWORD=root -d mysql:8.0.17 --default-authentication-plugin=mysql_native_password
# 开放端口
docker run --name mysql8 -e MYSQL_ROOT_PASSWORD=root -p 3306:3306 -d mysql:8.0.17 --default-authentication-plugin=mysql_native_password

自定义配置文件加，挂载到外部（推荐）

docker run --name mysql8 -v /opt/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=root -p 3306:3306 --restart=always -d mysql:8.0.17 --default-authentication-plugin=mysql_native_password

# 增加默认字符集配置
docker run --name mysql8 -v /opt/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=root -p 3306:3306 --restart=always -d mysql:8.0.17 --default-authentication-plugin=mysql_native_password --character-set-server=utf8mb4 --collation-server=utf8mb4_unicode_ci

# 持久化数据 -v /my/own/datadir:/var/lib/mysql
docker run --name mysql8 \
	-v /opt/mysql/conf:/etc/mysql/conf.d \
	-v /opt/mysql/datadir:/var/lib/mysql \
	-e MYSQL_ROOT_PASSWORD=root -p 3306:3306 --restart=always -d mysql:8.0.17 --default-authentication-plugin=mysql_native_password 

docker-compose

# Use root/example as user/password credentials
version: '3.1'

services:

  db:
    image: mysql
    command: --default-authentication-plugin=mysql_native_password
    restart: always
    environment:
      MYSQL_ROOT_PASSWORD: example

  adminer:
    image: adminer
    restart: always
    ports:
      - 8080:8080

或者
mysql 部署
docker-compose 部署

version: '3'
services:
  mysql-5.7:
    container_name: mysql-5.7
    hostname: mysql-5.7
    image: "mysql:5.7"
    restart: always
    ports:
      - "33060:3306"
    volumes:
      - "./data/mysql/logs:/etc/mysql/logs"
      - "./data/mysql/data:/var/lib/mysql"
      - "./data/mysql/conf:/etc/mysql/conf.d"
    environment:
      - MYSQL_ROOT_PASSWORD=password
    command:
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_unicode_ci
      --default-time_zone='+8:00'
    networks:
      - network-base

网络不存在需要添加
networks:
network-base:
external: true

minio 部署
docker-compose 部署

version: '3'
services:
  minio:
    container_name: minio
    image: minio/minio:latest
    hostname: minio
    ports:
      - 9000:9000 # api 端口
      - 9001:9001 # 控制台端口
    environment:
      MINIO_ACCESS_KEY: admin
      MINIO_SECRET_KEY: abc.123456
    volumes:
      - ./data/minio/data:/data
    command: server --console-address ':9001' /data
    privileged: true
    restart: always
    networks:
      - network-base

mysql8 sql_mode问题

问题：

select @@GLOBAL.sql_mode;

mysql8 的 sql_mode
ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

mysql5 的 sql_mode
BY,STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION

解决方法

5分钟学会MySQL-this is incompatible with sql_mode=only_full_group_by错误解决方案 https://blog.csdn.net/qq_42175986/article/details/82384160

删除sql_mode 中的 ONLY_FULL_GROUP_BY

1. 临时方法
   执行如下命令，mysql重启后失效

set @@GLOBAL.sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

2. 永久

完美解决方案。

需修改mysql配置文件，通过手动添加sql_mode的方式强制指定不需要ONLY_FULL_GROUP_BY属性，

my.cnf位于etc文件夹下，vim下光标移到最后，添加如下：

sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

文件内容

[mysqld]
sql_mode=STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION

caching_sha2_passord

ocker部署MySql，解决‘caching_sha2_passord’问题、时区问题等 https://blog.csdn.net/weixin_43841693/article/details/102862938