docker搭建mysql创建用户限制连接

通过docker安装mysql
docker run -itd --name mysql-test -p 3306:3306 -e MYSQL_ROOT_PASSWORD=sqqadmin mysql
查看docker使用的ip
docker inspect -f '{{range .NetworkSettings.Networks}}{{.IPAddress}}{{end}}' mysql-test

！！！mysql8加密过高，需要修改加密方法才能进行连接
查看安全策略
SHOW VARIABLES LIKE 'validate_password%';
set global validate_password_policy=LOW;  \\等级
set global validate_password_length=6;   \\长度

新建用户
CREATE USER 'zhoushun'@'%' IDENTIFIED BY 'zhoushun123';
给用户performance_schema使用权限
GRANT ALL PRIVILEGES ON performance_schema.* TO 'zhoushun'@'%';
刷新权限
FLUSH PRIVILEGES;