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

admin

MariaDB [(none)]> show variables like 'lower_case_table_names';
+------------------------+-------+
4 K! X8 ~, r: p3 G8 q* ?| Variable_name          | Value |
+------------------------+-------+
$ S: Y& Y: Z( w( z2 B  z9 H| lower_case_table_names | 1     |
+------------------------+-------+
4 k+ N* t" b9 t$ g( G1 row in set (0.00 sec)用户权限
MariaDB [(none)]> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
, y5 W0 D: V: N; f/ p, n( c* u' b+-------------------------------+
; t2 E( o, {3 b( u| query                         |
+-------------------------------+
| User: 'activemq'@'%';         |
9 i4 I4 ?- B# |6 Z| User: 'opuser'@'%';           |
| User: 'root'@'%';             |
| User: 'test'@'%';             |
  p( R: o. y& K: W
) g4 u, ?* X  c' {+ F2 a+ U

admin

在my.cnf的[mysqld]中添加
lower_case_table_names = 1

' S3 w1 ~3 ?: G" Y8 I# _重启mysql服务即可