2020红亚杯：MySql添加用户、访问权限

mysql 创建用户 访问权限开放

进入MySQL

MySQL -uroot -p

修改密码策略

set global validate_password_policy=0;

set global validate_password_length=4;

创建用户 用户名为 qingjiao 密码设置为123456

create user 'qingjiao'@'%' identified by '123456';

grant all privileges on *.* to 'root'@'%' with grant option;

flush privileges;