|
|
mysql> select distinct concat('User: ''',user,'''@''',host,''';') as query from mysql.user;
2 M, N8 p2 D9 {: T. ~* M4 q5 k+ z+---------------------------------+
. l; p' Y0 H$ g }9 L! s$ w9 F| query |7 q4 @, c S' ]9 @+ h
+---------------------------------+4 ]. m/ K; Z7 P# _& H4 l6 O: Q
| User: 'expiretest'@'%'; |- H4 D G% ?8 ^" ^/ {+ v: M% Y6 ^
| User: 'root'@'%'; |# A! }) j: Z) I+ y2 b2 v1 e
| User: 'ysw'@'%'; |% \( b) t B7 G2 `4 M5 H
| User: 'root'@'127.0.0.1'; |
, Z, |2 k7 h; A* Z9 o3 ?+ t0 s; k6 F| User: 'root'@'::1'; |% ^( ~1 U$ h$ {( X6 Y
| User: ''@'centos6'; |
% g6 u& S9 b! z/ W/ ^# `6 g| User: 'root'@'centos6'; |
$ x; T3 D1 k+ Z$ |6 y| User: ''@'localhost'; |, R0 D) ^5 T: y% k+ z3 g: s: I5 Z2 ~% B
| User: 'expiretest'@'localhost'; |
% u; ~8 r9 y/ x| User: 'root'@'localhost'; |. @5 O! J- ]! T a
+---------------------------------+
0 @9 y2 _/ j k& r! }7 }10 rows in set (0.00 sec)
. O% i- E) ]1 e4 B; c+ J( U- m, t/ @$ b% D& W& Y/ \
mysql> drop user 'root'@'z%';
, n+ X# r6 {* `% n. vQuery OK, 0 rows affected (0.00 sec)
7 `" j* X: I0 j- c- B
& A! ?5 B- P" b+ k* `/ E4 v! I3 z, m' } ~6 `
|
|
发表于 2020-6-17 11:54:06