Docker mysql8.0

docker run --name mysql -e MYSQL_ROOT_PASSWORD=123456 -d mysql

mkdir -p /usr/mysql/{conf,data}

docker cp mysql:/var/lib/mysql /usr/mysql/data

docker cp mysql:/etc/mysql/my.cnf /usr/mysql/conf/my.cnf

docker rm -f mysql

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

进入容器改密码及密码插件:alter user 'root'@'%' identified with mysql_native_password by 'xxxxxx';