|
|
MariaDB [(none)]> show variables like 'lower_case_table_names';7 E! W1 H5 o- \% S# }
+------------------------+-------+4 K% l- a5 h E# t: k' u1 X Y5 C
| Variable_name | Value |
/ N7 A5 ~& D+ I; X' E% l0 T; R+------------------------+-------+0 Y b2 V' c7 B9 U1 L1 I" }
| lower_case_table_names | 1 |
* d0 _9 d+ U) t: }; O5 W9 R+------------------------+-------+
# f# o8 h1 j; j {1 row in set (0.00 sec)用户权限 H3 d5 L0 p8 B* v6 e
MariaDB [(none)]> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;/ K# |9 m7 P% V8 p5 g7 ~: t
+-------------------------------+' P4 d5 J2 E, f y h+ ?& I
| query | h/ Y+ K, r7 n: [2 o
+-------------------------------+
! O* q! f* L, t+ }/ K7 b; H* z| User: 'activemq'@'%'; |
: _/ E- j+ [& E" S' C. d1 u| User: 'opuser'@'%'; |
, {7 K3 L' D4 i* @| User: 'root'@'%'; |
; A( O# R* P6 _# O4 A| User: 'test'@'%'; |) w3 ^' f: U2 I4 w
+ _5 w# L; @: Q) p: q
|
|
发表于 2017-9-7 09:33:28