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

退出容器即可连接了