docker 中下载 mysql

docker pull mysql

启动

docker run –name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=roor! -d mysql

进入容器

docker exec -it mysql bash

登录mysql

mysql -u root -p
ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘roor!’;

添加远程登录用户

CREATE USER ‘roor’@’%’ IDENTIFIED WITH mysql_native_password BY ‘roor!’;
GRANT ALL PRIVILEGES ON . TO ‘roor’@’%’;