添加网段:
docker network create --subnet=172.18.0.0/18 mynet
执行命令:
docker run -it -d --name mysql_1 -p 7001:3306 \
--net mynet --ip 172.18.0.2 \
-m 400m -v /root/mysql_1/data:/var/lib/mysql \
-v /root/mysql_1/config:/etc/mysql/conf.d \
-e MYSQL_ROOT_PASSWORD=123456 \
-e TZ=Asia/Shanghai --privileged=true \
docker.io/mysql:5.7.35 \
--lower_case_table_names=1
开启远程访问权限
docker exec -it mysql_1 bash
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456abc';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456abc' WITH GRANT OPTION;
flush privileges;