|
|
MariaDB [(none)]> revoke all privileges,grant option from 'huk'@'%'; 回收权限5 r0 I8 b- U' e6 T1 }
& O% P+ Z; X, w. E! [' T3 R
MariaDB [(none)]> select host,user,password,insert_priv,select_priv,grant_priv from mysql.user where user='hulk'\G
# J8 w/ p$ B4 }9 {: a0 K*************************** 1. row ***************************& b0 p0 z, g% Y$ T
host: localhost
1 a) M7 G/ A# } p user: hulk
' Y& S7 C# o3 r# ^! | password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97' m# b0 G9 O2 Z2 s# D2 ?* H; n1 Q
insert_priv: N: p! d- H0 a5 G4 x
select_priv: N' T3 ~, ]* M: \' T2 p: b
grant_priv: N
! Q- _2 Q* _! O( i*************************** 2. row ***************************4 P& h# T1 {% ^2 _ p7 c7 S% o
host: %
9 O7 B' q* n2 u user: hulk2 s/ C' s$ `$ |! {( s* t& I9 k$ {
password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97( n6 i. s' H' c. I
insert_priv: N
2 { P* h/ m" K/ U1 fselect_priv: N
( R9 d7 W0 `9 b) ~' x0 [ grant_priv: N* o3 ^/ q' {4 ?3 J1 p* J& b& Y* r& J1 d
2 rows in set (0.00 sec)1 j8 x2 N( z; e- U
7 C" q3 C2 S4 d" x# Z. Y
* _6 E+ S1 d8 A9 n4 qMariaDB [(none)]> show grants;& e+ e9 T+ R7 {; u0 n$ @. A
+----------------------------------------------------------------------------------------------------------------------------------------+
9 m1 n3 d, m8 {' V# J- ^| Grants for root@localhost |0 z4 Q) Y0 R2 M# W6 @- v7 W i, w
+----------------------------------------------------------------------------------------------------------------------------------------+
3 a% A. Y8 N. e$ G* @| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*04016E8BF07ED5FC7C2B59D2E01885B0876E448D' WITH GRANT OPTION |, ]( q7 E- K6 [! ^. h
| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
1 b' S% M; C& Q7 v2 o7 R# e+----------------------------------------------------------------------------------------------------------------------------------------+
" I8 A0 R) P2 U; q2 rows in set (0.00 sec)5 R. D' j4 B, K1 k
! V) _) }5 P$ ~( O! e: F: a
|
|
发表于 2018-7-6 11:31:30