+--------------+---------+-------------------------------------------+------------+------------+
| host | user | password | Grant_priv | Super_priv |
+--------------+---------+-------------------------------------------+------------+------------+
|
192.168.
28.% | oozie | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | N | Y |
|
192.168.
28.% | hive | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | N | Y |
|
192.168.
28.% | root | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | Y | Y |
| localhost | ranger | *84BB87F6BF7F61703B24CE1C9AA9C0E3F2286900 | N | N |
| localhost | root |
0 | Y | Y |
| % | root | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | N | Y |
|
127.0.
0.1 | root | *FED29C14B2E900D70B11B1F1B370F953BA51A6A0 | Y | Y |
| % | ranger | *84BB87F6BF7F61703B24CE1C9AA9C0E3F2286900 | N | Y |
+--------------+---------+-------------------------------------------+------------+------------+
可以看到授权的权限没有打开： Grant_priv is set to N for root@%. 修复下
UPDATE mysql.user SET Grant_priv=‘Y‘, Super_priv=‘Y‘ WHERE User=‘root‘; FLUSH PRIVILEGES;
重新登录下，就ok了。
Error Code: 1044. Access denied for user 'root'@'%' to database
标签：for ase localhost style oozie 授权 登录 error color
