show variables like 'lower_case_table_names%'



mysql> show variables like 'lower_case_table_names';

+------------------------+-------+

| Variable_name          | Value |

+------------------------+-------+

| lower_case_table_names | 0     |

+------------------------+-------+

1 row in set



my.cnf 에서 1로 값 변경

[mysqld]

lower_case_table_names=1

Posted by [czar]
,