Access denied for user xiaoqiu@localhost (using password :NO)
resolution:
- 删除匿名用户(mysql.user表中user为空的用户)
delete from user where mysql.user='';
- 生效(更改了用户表,用户的权限都需要执行,否则需要重启MySQL服务)
flush privileges;
Access denied for user xiaoqiu@localhost (using password :NO)
resolution:
delete from user where mysql.user='';
flush privileges;