Docker安装mysql8

docker 中下载 mysql

docker pull mysql

#启动
docker run --name mysql -p 3306:3306 -e MYSQL_ROOT_PASSWORD=Lzslov123! -d mysql

#进入容器
docker exec -it mysql bash

#登录mysql
mysql -u root -p
ALTER USER ‘root’@‘localhost’ IDENTIFIED BY ‘123456’;

#添加远程登录用户
CREATE USER ‘xixihaha’@’%’ IDENTIFIED WITH mysql_native_password BY ‘123456’;
GRANT ALL PRIVILEGES ON . TO ‘xixihaha’@’%’;

注意用navicate连接可能会有2013的情况，解决方法：
#修改登录者的权限
GRANT ALL ON . TO ‘root’@’%’;
#刷新命令生效
flush privileges;