查看数据库用户权限、删除用户权限

admin

grant all on *.* to 'account'@'192.168.0.%' identified by 'acc430';   某网段的地址能看见

# @6 P" s5 @' \8 X# j% g0 Igrant ALL PRIVILEGES on hive.* to "huk"@"12.168.20.%" Identified by "QgRQUswB0";
9 I2 _: ~9 X" d) _$ d/ V

admin

mysql> show grants;
. m/ k! o9 s8 ^- Z$ ^0 E+----------------------------------------------------------------------------------------------------------------------------------------+
& a, P  h! L! |" c  d| Grants for root@localhost                                                                                                              |
+----------------------------------------------------------------------------------------------------------------------------------------+
3 G# v9 _7 H: G- l| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' WITH GRANT OPTION |
4 |5 L3 V# h% C5 |2 r  _+ }| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |
1 T7 [( o0 N% e9 i+----------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)