|
|
MariaDB [(none)]> show variables like 'lower_case_table_names';4 {. g4 `3 ~& g9 Q! I
+------------------------+-------+
% B0 ^/ p( O) Y; K, n* g% J. A| Variable_name | Value |+ C" S* F* V1 H& j
+------------------------+-------+' N# l( `, S7 t& b- b( R
| lower_case_table_names | 1 |9 K2 m: }3 C- y( E
+------------------------+-------+
- C5 o+ @% C* O0 x, Z7 T1 row in set (0.00 sec)用户权限
# P- P1 ]" V) y- ^0 I% F( YMariaDB [(none)]> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;8 [" a r' P0 F% G+ b; ]$ ~8 R
+-------------------------------+
' I% K" K, q+ V9 O' T| query |4 d+ T! M1 K. V. d
+-------------------------------+7 o0 I/ ?5 {; j! {
| User: 'activemq'@'%'; |
+ K; D& p6 Y( ^3 H, W* t| User: 'opuser'@'%'; |# C0 x; b9 A l: ]2 e
| User: 'root'@'%'; |" U. F* C" C8 {! i! s
| User: 'test'@'%'; |
0 m) H$ e% N) B; Y* E( z$ o0 z. j. z! F( Y! w! u
|
|
发表于 2017-9-7 09:33:28