centos 7.9下用docker装mysql

一、写docker-compose.yaml

version: "3.8"
services:
  mysql-master:
    image: mysql:latest
    container_name: mysql_master_test
    command: --default-authentication-plugin=mysql_native_password
    restart: always
    ports:
      - 192.168.1.xx:3308:3306
      - 192.168.1.xx:33080:33060
    volumes:
      - ./data:/var/lib/mysql
    environment:
      - MYSQL_ROOT_PASSWORD=root.purch.com
      - MYSQL_PORT=3306
      - MYSQL_USER=purch
      - MYSQL_PASSWORD=purch.com
      - MYSQL_DATABASE=purchase

二、运行docker-compose.yaml《启动容器》

docker-compose up --build -d

三、进入容器里

docker exec -it mysql_master_test /bin/bash

四、连接mysql

mysql -uroot -p

Enter password: root.purch.com

五、修改用户访问地址设置并刷新权限

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root.purch.com';
flush privileges;

六、退出容器进行连接

exit


mysql -h 192.168.1.xx -P 3308 -u root