Mysql table name is case-insensitive setting method _mysql

The original Linux under the MySQL default is the table name is case-sensitive, through the following settings, you can make MySQL does not distinguish table name case:
1, with root login, modify/etc/my.cnf;
2, under the [Mysqld] node, add a line: Lower_case_table_names=1
3, restart MySQL can be;

Where the Lower_case_table_names=1 parameter defaults to 1 in Windows, 0 in Unix, and therefore does not encounter problems in window, Once you have been to Linux will cause problems (especially in MySQL when the table name can not be used in uppercase letters, and query with uppercase letters will be found in the error, it is really confusing)