docker安装mysql

84 阅读1分钟

添加网段:

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;