win10 Docke安装mysql8.0

docker 中下载 mysql

docker pull mysql

启动

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

进入容器

docker exec -it mysql bash

登录mysql

mysql -u root -p
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

添加远程登录用户

CREATE USER 'tpr'@'%' IDENTIFIED WITH mysql_native_password BY '123456';
GRANT ALL PRIVILEGES ON *.* TO 'tpr'@'%';