docker 本地搭建mysql 5.7 开发环境

docker-compose.yml

version: '3'
services:
  mysql:
    image: mysql:5.7
    container_name: mysql
    restart: always
    ports:
      - 0.0.0.0:3306:3306
    environment:
      - MYSQL_ROOT_PASSWORD=123456
      - MYSQL_USER=wss
      - MYSQL_PASSWORD=123456
    volumes:
      - mysql-etc-data:/etc/mysql
      - mysql-data:/var/lib/mysql
      - mysql-log:/var/log/mysql

volumes:
    mysql-etc-data:
    mysql-data:
    mysql-log:

登录mysql

mysql -h 127.0.0.1 -u root -p123456

赋予用户wss远程登录权限

GRANT ALL PRIVILEGES ON *.* TO 'wss'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
FLUSH PRIVILEGES;