|
|
MariaDB [(none)]> show variables like 'lower_case_table_names';9 x0 l% T8 g- E8 l* y
+------------------------+-------+- w8 W+ M9 z: u p/ d- T
| Variable_name | Value |: K! b- P8 s+ Z7 V" P+ f
+------------------------+-------+$ I# v4 c: ]# L: D' N" `0 |9 T |
| lower_case_table_names | 1 |
( K0 ^$ n/ ]* F7 X9 c+------------------------+-------+
6 R" l5 W4 L8 o, U. X2 V1 row in set (0.00 sec)用户权限- ~7 Q& W: S: B4 w$ _
MariaDB [(none)]> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
" n7 T# v7 W" g+-------------------------------+$ i- q1 u& w" R) A |
| query |8 K7 Y3 @4 L- o9 h1 E
+-------------------------------+
6 W" X. l) ~( w: F- c7 x' y: {| User: 'activemq'@'%'; |
! f4 \! d! f0 \0 Z| User: 'opuser'@'%'; |
( a2 E3 J! `, ^9 |- T% _| User: 'root'@'%'; |
$ V n7 V0 H3 ~# I3 k| User: 'test'@'%'; |# V4 X; Y A# c+ a
& G, |( q; ]2 b' f L, o/ ]
|
|
发表于 2017-9-7 09:33:28