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

admin

grant all on *.* to 'account'@'192.168.0.%' identified by 'acc430';   某网段的地址能看见
5 F0 K# c2 g4 R9 |. k! z
grant ALL PRIVILEGES on hive.* to "huk"@"12.168.20.%" Identified by "QgRQUswB0";

admin

mysql> show grants;
9 K& R6 R2 i7 l8 N  q7 B+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost                                                                                                              |
2 d9 o& Z& L+ g4 e8 P+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*6BB4837EB74329105EE4568DDA7DC67ED2CA2AD9' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |
- V. T9 r* J/ `9 I/ E) X2 x7 ~+----------------------------------------------------------------------------------------------------------------------------------------+
; h7 |# x- @. r& Y# j9 p( M2 rows in set (0.00 sec)