docke安装mysql

 pwd
 /opt
 mkdir -p docker_v/mysql/conf
 cd docker_v/mysql/conf
 touch my.cnf
 docker run -p 3306:3306 --name mysql -v  /opt/docker_v/mysql/conf:/etc/mysql/conf.d -e MYSQL_ROOT_PASSWORD=123456 -d imageID

#进入容器
docker exec -it mysql bash

#登录mysql
mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY 'huagezuishuai!';

#添加远程登录用户
CREATE USER 'xxx'@'%' IDENTIFIED WITH mysql_native_password BY 'huagezuishuai!';
GRANT ALL PRIVILEGES ON *.* TO 'xxx'@'%';