查看数据库是否忽略大小写

admin

MariaDB [(none)]> show variables like 'lower_case_table_names';
( J/ M- V" i0 _8 t7 ?, H$ j! @6 T/ p+------------------------+-------+
' H( m( B( ^3 L9 G7 q& Z2 ^| Variable_name          | Value |
+------------------------+-------+
( Z  i$ A" K9 T' B' }| lower_case_table_names | 1     |
% @6 {) j( l$ }* P4 q8 L+------------------------+-------+
1 row in set (0.00 sec)用户权限
MariaDB [(none)]> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
" p0 V6 g( U# F, L+-------------------------------+
7 i0 Z8 V4 I/ R  Y; b& R7 k| query                         |
' k8 D8 s& o7 [0 I% c6 L: Q9 {1 e2 |: z. {+-------------------------------+
| User: 'activemq'@'%';         |
| User: 'opuser'@'%';           |
| User: 'root'@'%';             |
6 J( {- p# O7 o; f/ {| User: 'test'@'%';             |
7 i% }4 R: \: m3 e! K

admin

在my.cnf的[mysqld]中添加
0 P7 _: ]  v1 s& Mlower_case_table_names = 1

6 D) \, W1 R8 U  V4 }" W重启mysql服务即可