MySQL新建用户无法登录

Access denied for user xiaoqiu@localhost (using password :NO) 

 

resolution:

• 删除匿名用户（mysql.user表中user为空的用户）

delete from user where mysql.user='';

• 生效(更改了用户表，用户的权限都需要执行，否则需要重启MySQL服务)

flush privileges;