数据库回收权限revoke

admin

MariaDB [(none)]> revoke all privileges,grant option from 'huk'@'%';     回收权限
! i7 W1 L# X$ b9 X6 d  j! ~
MariaDB [(none)]> select host,user,password,insert_priv,select_priv,grant_priv from mysql.user where user='hulk'\G
4 w% e( x% v( R0 t- F*************************** 1. row ***************************
% @$ c) T, Q; P% o& l       host: localhost
       user: hulk
   password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97
; X7 @* a# \6 n/ c( Minsert_priv: N
8 B& B; \) g- Q' i3 ~select_priv: N
grant_priv: N
' M2 u2 o5 `: ]) @$ N*************************** 2. row ***************************
       host: %
       user: hulk
   password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97
! F; R  ~6 B5 f2 f% M/ ]# p1 ginsert_priv: N
9 f8 r: Y  Y: c1 N  Y0 Bselect_priv: N
4 K  e; T% h$ C3 {: k grant_priv: N
5 m! [' z( Y0 I6 {& f2 rows in set (0.00 sec)


3 ^( R; o6 C# A* S0 l! wMariaDB [(none)]> show grants;
- c7 S: M( |1 i4 a" D+----------------------------------------------------------------------------------------------------------------------------------------+
2 Z" U; i+ I2 {$ m9 Z| Grants for root@localhost                                                                                                              |
+----------------------------------------------------------------------------------------------------------------------------------------+
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*04016E8BF07ED5FC7C2B59D2E01885B0876E448D' WITH GRANT OPTION |
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION                                                                           |
+----------------------------------------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)