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’@’%’;
发表回复