|
|
MariaDB [(none)]> revoke all privileges,grant option from 'huk'@'%'; 回收权限
: i; m; ] N- I! N+ ?. k h! P- `3 j3 R. {; K1 y# J
MariaDB [(none)]> select host,user,password,insert_priv,select_priv,grant_priv from mysql.user where user='hulk'\G3 G* `. T* v4 G- d
*************************** 1. row ***************************3 u& z T" U. T/ l9 o+ C/ a
host: localhost
9 l' c& I" s, y# E. u1 w5 K user: hulk; H+ J" u3 Y2 f$ X/ c
password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97
. z; s0 P* D; d" hinsert_priv: N7 Z8 j; T" }2 [/ B+ f7 s! K
select_priv: N
- X* }" _2 N* m grant_priv: N7 l' S3 d( n! Q
*************************** 2. row ***************************
; G, G+ o. G; D) h) V" l/ O6 K. [& l4 V3 I host: %
+ B. k# D4 u: {3 a) p user: hulk' z% }5 W7 U/ I
password: *6E9F3B40D6355A5DCE0A4CEA75E3816D937CBB97
Y) A7 n. d* v- a0 e+ ninsert_priv: N* P, y% C4 {- ]. H. g2 H! N
select_priv: N. V! a6 p ]4 O; i% I* }
grant_priv: N
. b! c6 n: l/ V/ S4 [, U2 rows in set (0.00 sec)
6 P& f9 h6 ~; n: Z. n0 {0 m6 x/ [- Q! e3 T) S* [! v2 Q
3 ~: C; U$ R+ j- f9 fMariaDB [(none)]> show grants;
& b/ r" R# T4 T$ q8 N9 r+ o; x+----------------------------------------------------------------------------------------------------------------------------------------+6 w6 ~% A& |7 J x/ M! `& d: S
| Grants for root@localhost |" j2 q! n% S L" \; N* n
+----------------------------------------------------------------------------------------------------------------------------------------+
- ~1 p( u" a' w, m$ n$ K( y| GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY PASSWORD '*04016E8BF07ED5FC7C2B59D2E01885B0876E448D' WITH GRANT OPTION |
$ i k6 N1 k9 O1 w/ C# S$ z# r9 P| GRANT PROXY ON ''@'' TO 'root'@'localhost' WITH GRANT OPTION |
) ^6 U8 ]- g7 n! G# _) S+----------------------------------------------------------------------------------------------------------------------------------------+3 A; V# d- h+ U0 q
2 rows in set (0.00 sec)
P* P, i3 P; F; v$ v& o
/ `$ E; k: q, x+ B/ t, T" x! Z |
|
发表于 2018-7-6 11:31:30