mysql 在线安装后基础配置

修改策略，及密码长度

set global validate_password_length=1;

set global validate_password_policy=0

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';

ALTER USER 'root'@'localhost' PASSWORD EXPIRE NEVER;

FLUSH PRIVILEGES;

修改权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'YYBrhr_2018' WITH GRANT OPTION;

FLUSH PRIVILEGES;