Docker MySQL

docker 中下载 mysql

docker pull mysql

启动

docker run —name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql

挂载数据

docker run  -p 3306:3306 -v /e/zm/docker/mysql/conf:/etc/mysql/conf.d -v /e/zm/docker/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 --privileged=true -d mysql

进入容器

docker exec -it mysql bash

登录mysql

mysql -u root -p
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘123456’;

添加远程登录用户

CREATE USER ‘root’@’%’ IDENTIFIED WITH mysqlnative_password BY ‘123456 ‘;
GRANT ALL PRIVILEGES ON ._ TO ‘root’@’%’;