|
|
MariaDB [(none)]> revoke all privileges,grant option from 'huk'@'%'; 回收权限2 i5 Z! O. v' i6 ] l1 ]& }
# K* Z" y0 u( \/ E7 W
MariaDB [(none)]> select host,user,password,insert_priv,select_priv,grant_priv from mysql.user where user='hulk'\G
! J" T& ? Z p/ s*************************** 1. row ***************************
9 Y- ]$ }) P K* C host: localhost% [3 k# ?3 r7 J, P9 p# L7 X$ }% ~
user: hulk) q" A1 T4 S/ y
password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97
# G/ P5 e* x* Ninsert_priv: N
, z2 \, t0 g: M. ^. k% }select_priv: N
7 f/ J! V( ] l3 M+ D: G! K, @7 } grant_priv: N
2 R5 Y$ k& F: r+ M" q& S3 c; i8 W*************************** 2. row ***************************7 E/ S# r3 P# B4 _% v* P: ]- Y
host: %5 k' e) a J2 n& M/ U) O, Y
user: hulk
7 v$ M i+ }2 F; u' i& P& Q6 e# i | password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97' E5 h; P' \) v
insert_priv: N
% N! K/ P( f4 \$ H& Fselect_priv: N, v5 M# `% W9 i' X
grant_priv: N$ X: ^2 ^1 U2 h5 o
2 rows in set (0.00 sec)
! t* t1 F7 W/ _! R7 T; p2 P" s" p1 u2 y! K( n0 ~1 z
" D% e5 e& V9 Y9 }. T( s/ k
MariaDB [(none)]> show grants;7 u& ]1 z/ Q0 _( x
+----------------------------------------------------------------------------------------------------------------------------------------+: J, ~4 r1 h% T W# x5 Z* w2 N3 K
| Grants for root@localhost |9 p6 N6 F4 m( q; E7 j& H" I& m
+----------------------------------------------------------------------------------------------------------------------------------------+4 q; T" m$ L7 {, q" z+ [
| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*04016E8BF07ED5FC7C2B59D2E01885B0876E448D' WITH GRANT OPTION |: a; R4 R/ ~& K! R6 W. @2 R
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
9 w) d3 }4 c- |& x( D+----------------------------------------------------------------------------------------------------------------------------------------+
6 G3 c, ]/ H O# \2 rows in set (0.00 sec)
/ P! `- E+ e: o6 H* J @3 _, z3 L/ O3 h1 J, ]
|
|
发表于 2018-7-6 11:31:30