[Err] 1044 - Access denied for user 'lon'@'%' to database 'lon'

悠悠 2024-02-17 23:58 144阅读 0赞

1、创建用户时报错

grant select on lon.* to ‘data’@’%’ identified by ‘Bi’;
[Err] 1044 - Access denied for user ‘lon’@’%’ to database ‘lon’

以root用户登录mysql的，怎么还会遇到这问题

2、查看权限 

  1. mysql> SELECT host,user,password,Grant_priv,Super_priv FROM mysql.user;
  2. +--------------+---------+-------------------------------------------+------------+------------+
  3. | host         | user    | password                                  | Grant_priv | Super_priv |
  4. +--------------+---------+-------------------------------------------+------------+------------+
  5. | 192.168.28.% | oozie   | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | N          | Y          |
  6. | 192.168.28.% | hive    | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | N          | Y          |
  7. | 192.168.28.% | root    | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | Y          | Y          |
  8. | localhost    | ranger  | *84BB87F6BF7F61703B24CE1C9AA9C0E3F2286900 | N          | N          |
  9. | localhost    | root    | 0                                         | Y          | Y          |
  10. | %            | root    | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | N          | Y          |
  11. | 127.0.0.1    | root    | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | Y          | Y          |
  12. | %            | ranger  | *84BB87F6BF7F61703B24CE1C9AA9C0E3F2286900 | N          | Y          |
  13. +--------------+---------+-------------------------------------------+------------+------------+

可以看到授权的权限没有打开： Grant_priv is set to N for root@%. 修复下

3、打开权限 

  1. UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';
  2. FLUSH PRIVILEGES;
  3.  4、重新创建用户即可；

发表评论

表情：
评论列表 （有 0 条评论，144人围观）

还没有评论，来说两句吧...

相关阅读