阿里云部署mysql密码修改无效问题

1.刷新权限表

flush privileges;

2.初始化无密码，设置密码

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

3.登陆阿里云，设置安全组3306