|
|
mysql> select distinct concat('User: ''',user,'''@''',host,''';') as query from mysql.user;
+ L4 M( M! J; L+---------------------------------+& z' k, _) a, e
| query |' ^$ M+ X! _- t( B2 x; Z
+---------------------------------+8 ^* B4 v, s1 [1 q, X1 R9 b
| User: 'expiretest'@'%'; |
3 y) c9 M+ f% I) H$ Y. E8 c. j| User: 'root'@'%'; |
% ^0 E7 p4 T' f$ c' z# K| User: 'ysw'@'%'; |, b) ~- A2 L' @- J3 b D" C- S
| User: 'root'@'127.0.0.1'; |
2 a' B+ Q: X; y9 c8 `6 R) L| User: 'root'@'::1'; |
. Z& h2 D, z2 i' S# I5 O! s7 ?| User: ''@'centos6'; |
5 {5 F! M3 W" ^4 u e6 b6 \| User: 'root'@'centos6'; | m, c/ u z2 U% U u
| User: ''@'localhost'; |
8 W/ U. `) M4 Z8 @, ]" D: P5 I' H) \| User: 'expiretest'@'localhost'; |- M; R x$ M, @
| User: 'root'@'localhost'; |
; S7 b& [0 F7 r) I: ]9 ]+---------------------------------+
2 Q# [) n8 {3 q# d# u10 rows in set (0.00 sec)% d& {9 |1 S( {% e% X
& ]& ^9 e; y) ?+ p
mysql> drop user 'root'@'z%';
6 B* o2 H* u& s7 ]4 Q3 Q+ O% n& E& QQuery OK, 0 rows affected (0.00 sec)
1 S4 c3 X3 P; {3 e7 Q) N9 B5 q& B, V3 o6 }% ]
, S4 h( U4 ^8 O |
|
发表于 2020-6-17 11:54:06