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

admin

MariaDB [(none)]> show variables like 'lower_case_table_names';
- ^. A8 T/ ]5 x3 x2 ^9 U) F8 ^+------------------------+-------+
| Variable_name          | Value |
; R! ~6 N3 s1 n+------------------------+-------+
| lower_case_table_names | 1     |
7 {& S: p5 e. ?: L% l9 Y+------------------------+-------+
1 row in set (0.00 sec)用户权限
& p2 u0 F- L) c2 t( kMariaDB [(none)]> SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
+-------------------------------+
: `# t$ t8 X( H# b2 \| query                         |
4 C' f+ d5 }2 |+-------------------------------+
& W2 j( b) q; Z7 ]2 v( A7 `| User: 'activemq'@'%';         |
# f( i- B% S; _8 [| User: 'opuser'@'%';           |
| User: 'root'@'%';             |
( X# b7 }; q* ^2 O5 O5 O; J6 y| User: 'test'@'%';             |

admin

在my.cnf的[mysqld]中添加
2 [8 P& }0 R( o$ Nlower_case_table_names = 1

( n0 F: p- |$ m重启mysql服务即可