mysql 创建用户后分配权限失败的解决方法

创建用户后要

FLUSH PRIVILEGES;

方可分配权限并登录。shit~~~

insert into mysql.user(Host,User,Password) values("%","featuregen",password("huawei"));
FLUSH PRIVILEGES;
grant all privileges on cf.* to featuregen@"%" identified by 'huawei';
FLUSH PRIVILEGES;