docker创建mysql镜像

docker pull mysql

docker run -p 3306:3306 --name mysql -e MYSQL_ROOT_PASSWORD=123456  -v /home/docker/mysql:/var/lib/mysql -d mysql

grant all PRIVILEGES on *.* to root@‘%‘ WITH GRANT OPTION;
ALTER user ‘root‘@‘%‘ IDENTIFIED BY ‘root@123456‘ PASSWORD EXPIRE NEVER;
ALTER user ‘root‘@‘%‘ IDENTIFIED WITH mysql_native_password BY ‘root@123456‘;