安装MySQL

#创建mysql数据卷地址
mkdir -p /opt/server/mysql && cd /opt/server/mysql
#创建docker-compose.yml文件，把密码`MYSQL_ROOT_PASSWORD`项修改下
sudo tee docker-compose.yml <<-'EOF'
version: '3.1'
services:
  db:
    image: biarms/mysql:5.7.30-linux-arm64v8
    restart: always
    container_name: mysql
    environment:
      - TZ=Asia/Shanghai
      - MYSQL_ROOT_PASSWORD=123456
    command:
      --default-authentication-plugin=mysql_native_password
      --sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=0
    ports:
      - 3306:3306
    volumes:
      - ./data:/var/lib/mysql
EOF
#启动mysql up->启动 -d 以守护方式运行
docker-compose -f docker-compose.yml up -d

sudo apt-get update
sudo apt-get install mysql-server
#设置账号密码
sudo mysql_secure_installation utility
#开启自启
sudo systemctl enable mysql
#重启
sudo systemctl restart mysql
#连接mysql
mysql -uroot -p

yum localinstall http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

yum -y install mysql-community-server

systemctl start  mysqld.service

 systemctl status mysqld.service

grep "password" /var/log/mysqld.log

version: '3.1'
services:
  db:
    image: mysql/mysql-server:8.0.22-1.1.18
    restart: always
    container_name: mysql
    environment:
      - TZ=Asia/Shanghai
      - MYSQL_ROOT_PASSWORD=123456
    command:
      --default-authentication-plugin=mysql_native_password
      --sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=0
    ports:
      - 3306:3306
    volumes:
      - ./data:/var/lib/mysql

version: '3.1'
services:
  db:
    image: biarms/mysql:5.7.30-linux-arm64v8
    restart: always
    container_name: mysql
    environment:
      - TZ=Asia/Shanghai
      - MYSQL_ROOT_PASSWORD=123456
    command:
      --default-authentication-plugin=mysql_native_password
      --sql_mode="STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION"
      --character-set-server=utf8mb4
      --collation-server=utf8mb4_general_ci
      --explicit_defaults_for_timestamp=true
      --lower_case_table_names=0
    ports:
      - 3306:3306
    volumes:
      - /etc/my.cnf:/etc/mysql/my.cnf
      - ./data:/var/lib/mysql