docker mysql 远程登录--搭建Gogs（compose编排)

compose文件

# mysql service
mydb:
  image: mysql:latest
  ports:
    - "13306:3306"
  environment:
    MYSQL_ROOT_PASSWORD: riversky
  volumes:
    - /opt/mydata2/:/var/lib/mysql
    - ./my.cnf:/etc/my.cnf
# gogs service
mygogs:
  image: gogs/gogs:latest
  ports:
    - "10033:22"
    - "3000:3000"
  volumes:
    - /var/gogs2/:/data
  links:
    - mydb

my.cnf

[mysqld]
user=mysql
default-storage-engine=INNODB
character-set-server=utf8
[client]
default-character-set=utf8
[mysql]
default-character-set=utf8

初始化脚本

docker-compose -p GogsApp up -d

#进入容器执行

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'iotsp2017';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'iotsp2017';
SELECT plugin FROM mysql.user WHERE User = 'root';