时间:2021-07-01 10:21:17 帮助过:83人阅读
3.1重启mysql命令
/etc/init.d/mysql restart
3.2再次验证
mysql> show variables like ‘%lower%‘;
+------------------------+-------+
| Variable_name | Value |
+------------------------+-------+
| lower_case_file_system | OFF |
| lower_case_table_names | 1 |
+------------------------+-------+
2 rows in set (0.00 sec)
mysql> select * from CM_VERSION;
+---------+--------------------------------------+---------------------+------+-----------------------------------+-----------------------+
| VERSION | GUID | LAST_UPDATE_INSTANT | TS | HOSTNAME | LAST_ACTIVE_TIMESTAMP |
+---------+--------------------------------------+---------------------+------+-----------------------------------+-----------------------+
| 5.13.3 | 1e440f97-6cea-403c-b712-f853b2a74752 | 1576748189778 | NULL | dataexa-cdh-test-01/192.168.1.228 | 1576830522188 |
+---------+--------------------------------------+---------------------+------+-----------------------------------+-----------------------+
1 row in set (0.00 sec)
mysql-5.7.26 版本,表不区分区分大小写问题
标签:socket 分区 cli purge cte host bin utf8 sel