mysql创建用户角色后无法登陆_解决方法

create user`yaoyan`@`%` identified by'123456';

 grant all on (数据库名）*.(表名，星号代表全部)* to dba@‘%’;
//例子
grant all on paike.* to 'litaige'@'%';
//刷新权限
flush privileges；

use mysql ;
select * from user where User='';
//如果存在
delete from user where User=''；
//
//再查询，如果不存在，
//刷新权限
flush  privileges

ALTER USER 'root'@'%' IDENTIFIED BY 'Lmk@19980312' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'Lmk@19980312'; #更新一下用户的密码
FLUSH PRIVILEGES; 
ALTER USER 'sy5'@'%' IDENTIFIED BY 'Lmk@123456' PASSWORD EXPIRE NEVER; #修改加密规则
ALTER USER 'sy5'@'%' IDENTIFIED WITH mysql_native_password BY 'Lmk@123456'; #更新一下用户的密码
FLUSH PRIVILEGES;