docker-compose部署mysql5.7不能远程连接？

Question

docker-compose.yml

mysql:
    image: mysql:5.7.26
    container_name: my-mysql
    restart: always
    command: --default-authentication-plugin=mysql_native_password
    ports:
      - 3306:3306
    volumes:
      - ./mysql/data/:/var/lib/mysql/
    environment:
      MYSQL_ROOT_PASSWORD : 12355

Answer 1

之前设置错误

执行 GRANT ALL ON . TO root@'%' IDENTIFIED BY '12233**' WITH GRANT OPTION;

flush privileges;

OK了