|
|
MariaDB [(none)]> revoke all privileges,grant option from 'huk'@'%'; 回收权限# b* J. g( `) g `, L' E
- h, {8 n) f2 V& X2 \! ]: sMariaDB [(none)]> select host,user,password,insert_priv,select_priv,grant_priv from mysql.user where user='hulk'\G
; f1 K9 `- x F" V; s' c*************************** 1. row ***************************# t9 d# _3 C6 f9 H* @2 l& k0 i
host: localhost
7 A3 }. e/ ]/ J u user: hulk
9 u1 S: d/ v& }( G password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB971 L' Y ]8 J0 ]! \
insert_priv: N
0 a" u) @: y5 ?3 F* mselect_priv: N
1 r' \1 U$ [1 c grant_priv: N
9 R) }( B8 n7 ]*************************** 2. row ***************************
( s. w4 c5 V6 W1 O" S host: %+ f* e# e; R1 {
user: hulk
) F/ B3 y, X D password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97
& h% R& @0 K" r. {insert_priv: N( ]# S. p% ^$ L5 f/ a' l
select_priv: N
% ^6 t* X6 f, w) p8 a1 U7 F grant_priv: N: Y0 p9 n6 N+ p! ~" N: i9 B
2 rows in set (0.00 sec)0 |6 K* `" N: q( f8 m
, E* R. P4 U# b; q' j" u4 C
& z" R+ @1 z2 y0 O' P3 V. \$ U7 L
MariaDB [(none)]> show grants;
8 T% e3 H7 Y5 i) ], L4 G& S+ M+----------------------------------------------------------------------------------------------------------------------------------------+/ e' E, I, x. t) L
| Grants for root@localhost |& H2 [' D/ j1 u" P9 H& Q
+----------------------------------------------------------------------------------------------------------------------------------------+, q1 M6 r j) g$ p/ @1 O
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*04016E8BF07ED5FC7C2B59D2E01885B0876E448D' WITH GRANT OPTION |
# W9 y7 g9 `2 K| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
, Y5 A7 x3 k3 S& o; y+----------------------------------------------------------------------------------------------------------------------------------------+7 [+ x7 a; e7 P9 L0 Y' p% r
2 rows in set (0.00 sec)4 i" A0 z2 w6 ~
7 R: c5 @+ u3 r) M1 r( _0 l2 z; e |
|
发表于 2018-7-6 11:31:30