数据库回收权限revoke

admin

MariaDB [(none)]> revoke all privileges,grant option from 'huk'@'%';     回收权限

( c  H6 Y# u6 H* F+ @MariaDB [(none)]> select host,user,password,insert_priv,select_priv,grant_priv from mysql.user where user='hulk'\G
* [4 X/ @+ b2 F3 p5 w& u*************************** 1. row ***************************
8 g' o  x' u; n' X1 P7 s       host: localhost
       user: hulk
   password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97
insert_priv: N
5 g/ K* a6 q: H- P2 }/ _select_priv: N
, l' ]# z  p% H: A. D; u grant_priv: N
1 B( b5 o( e1 x*************************** 2. row ***************************
       host: %
       user: hulk
9 O1 e; u( I+ m. k) ?0 w- S) p   password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97
. \! d" j* x) }1 A) V# U2 B1 B) Q6 Vinsert_priv: N
8 p7 b3 ^; Y  A/ i6 _# Vselect_priv: N
# q5 Y: _2 j; x5 {6 Y: v- W0 I  ` grant_priv: N
2 rows in set (0.00 sec)


MariaDB [(none)]> show grants;
+----------------------------------------------------------------------------------------------------------------------------------------+
| Grants for root@localhost                                                                                                              |
6 n( J5 y5 _. k; J+----------------------------------------------------------------------------------------------------------------------------------------+
0 H) O1 R$ s2 b3 G| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*04016E8BF07ED5FC7C2B59D2E01885B0876E448D' WITH GRANT OPTION |
9 m- y. G% o/ j& D| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |
+----------------------------------------------------------------------------------------------------------------------------------------+
# z0 ]5 w4 a2 ~" s7 }* y0 q2 rows in set (0.00 sec)
: W7 ]6 Y' c, L% S
) y- b9 I. ^, @: @