1.拉取mysql

docker pull mysql:latest

2.创建mysql容器

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

3.登陆mysql

docker exec -it mysql /bin/bash
mysql -u root -p

4.开启root远程访问

use mysql;
ALTER USER ‘root’@’%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
flush privileges;
select host,user,plugin,authentication_string from mysql.user;

5.重启mysql容器

docker restart mysql