centos7下docker-compose啟動mysql8，并開啟遠端連接配接

docker-compose檔案如下

version: '3'
services:
  mysql:
    container_name: werben-mysql
    image: mysql:8
    restart: always
    command: --default-authentication-plugin=mysql_native_password
    volumes:
      - ./data/:/var/lib/mysql/
      - ./conf/:/etc/mysql/
    ports:
      - "3306:3306"
    environment:
      - MYSQL_ROOT_PASSWORD=123456
      - LANG=C.UTF-8
      - TZ=Asia/shanghai
    networks:
      - default
networks:
  default:
    external:
      name: aimore
           

修改遠端權限

啟動容器

docker-compose up -d

進入容器

docker exec -it werben-mysql /bin/bash

連接配接mysql

mysql -u root -p

修改遠端權限

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '123456';

flush privileges

退出容器即可連接配接了