数据库回收权限revoke

admin

MariaDB [(none)]> revoke all privileges,grant option from 'huk'@'%';     回收权限
1 S5 H$ C0 Y- Z+ j
MariaDB [(none)]> select host,user,password,insert_priv,select_priv,grant_priv from mysql.user where user='hulk'\G
*************************** 1. row ***************************
6 }3 O+ k; {  \( Q" u* ~& [       host: localhost
# M3 z/ w3 `) M$ w7 A7 r       user: hulk
   password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97
insert_priv: N
select_priv: N
: U/ i. v" `4 G6 v grant_priv: N
/ Q% p; b6 }  q3 d*************************** 2. row ***************************
       host: %
  k$ u/ z1 E4 p2 w& y8 \       user: hulk
" G9 q+ ^' I# x* w4 A% X8 d7 L   password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97
6 a; z. y2 U- l0 F+ Pinsert_priv: N
select_priv: N
grant_priv: N
2 rows in set (0.00 sec)


MariaDB [(none)]> show grants;
5 }+ x5 c, r4 r" @" o6 I; |% B4 e+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost                                                                                                              |
7 }6 n; L8 e: E& X* W* L! b! J% E+----------------------------------------------------------------------------------------------------------------------------------------+
+ w9 _4 O5 R& P) k7 u- j" h| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*04016E8BF07ED5FC7C2B59D2E01885B0876E448D' WITH GRANT OPTION |
& c6 M" M) S: D| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |
+----------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)

5 O" _, r3 b% k