docke安装mysql

docke安装mysql"/>

docke安装mysql

 pwd/optmkdir -p docker_v/mysql/confcd docker_v/mysql/conftouch myfdocker 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'@'%';