数据库回收权限revoke

admin

MariaDB [(none)]> revoke all privileges,grant option from 'huk'@'%';     回收权限
4 M5 {6 ~& ^3 D3 q& x5 A
; x! J: X3 t- P  gMariaDB [(none)]> select host,user,password,insert_priv,select_priv,grant_priv from mysql.user where user='hulk'\G
4 ?* C% h) Y: w! k8 q. [*************************** 1. row ***************************
% s% [+ i! T. H       host: localhost
# B0 ?/ I; s! F       user: hulk
   password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97
9 L# j9 Z3 t8 |( c1 n% rinsert_priv: N
- |, R7 o0 S1 l/ i6 ]0 xselect_priv: N
grant_priv: N
& }0 y0 n8 g6 s9 O*************************** 2. row ***************************
. G' {' g3 Z1 Y0 E3 R       host: %
( i- Q4 f& F" O       user: hulk
   password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97
9 G- l" ^; l1 |7 |, w* k3 A2 h# G6 Cinsert_priv: N
. L3 ]8 M" K& h& c) B' x, L, q2 J4 Hselect_priv: N
grant_priv: N
  t/ q/ [) N! [6 q& H7 L. E, u  T2 rows in set (0.00 sec)
! C- h8 z* y3 C

& [4 K; s. J+ G* e9 @) JMariaDB [(none)]> show grants;
0 U( K3 k* p) C+ d+----------------------------------------------------------------------------------------------------------------------------------------+
7 P& x- c3 {- J9 G; e; ~| Grants for root@localhost                                                                                                              |
; b3 x; f2 W6 J' b+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*04016E8BF07ED5FC7C2B59D2E01885B0876E448D' WITH GRANT OPTION |
5 _$ ?' Y4 l' R$ u$ V% n| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |
+----------------------------------------------------------------------------------------------------------------------------------------+
( I% ~5 d+ L6 K/ R$ D. n2 rows in set (0.00 sec)

7 t! R7 D3 `% w