|
|
mysql> select distinct concat('User: ''',user,'''@''',host,''';') as query from mysql.user;
- r5 V' D' K: a+ A" S+---------------------------------+5 n. @: ~0 g' R( N' g- X
| query |0 [; F8 X- S4 z6 C Q
+---------------------------------+: F! e, ~0 s. K+ l7 d8 S% K; g
| User: 'expiretest'@'%'; |
( i$ w3 p' u3 z$ C| User: 'root'@'%'; |
1 ` S! y( }5 ~7 O0 \4 s9 \| User: 'ysw'@'%'; |
y4 y6 M5 h4 u$ b3 j- L" {; G# }| User: 'root'@'127.0.0.1'; |6 d. p7 N% D# v; e( ?0 }6 ~) `
| User: 'root'@'::1'; |2 l' P1 c0 ]4 o1 c
| User: ''@'centos6'; |. `# y) g5 o! m$ I: N
| User: 'root'@'centos6'; |8 ^6 g F; `. ?4 N; f- v
| User: ''@'localhost'; |
" {4 Y8 s2 [" N8 M| User: 'expiretest'@'localhost'; |& {4 u: [% U" {8 g& v+ E
| User: 'root'@'localhost'; |; H, T, ?% ~5 Q
+---------------------------------+
+ t+ y- s4 b0 p- a& ~% t10 rows in set (0.00 sec)
: a$ g1 _( Y6 T' W! k+ f
0 {' P6 U. W, V) Jmysql> drop user 'root'@'z%';1 s* U' k- R. E. @7 q, |4 {
Query OK, 0 rows affected (0.00 sec) N" u$ f8 `, d5 m/ v0 i9 L
0 N0 g3 ?5 }0 _/ k5 F- A
% N' R# U6 {1 o: U0 z) o1 O: J |
|
发表于 2020-6-17 11:54:06