MySQL table name case-Insensitive setting method

MySQL default is case-sensitive table name, with the following settings, you can let MySQL is not distinguished table name case:
1, log in with root, modify/etc/my.cnf;
2. Add a line under the [MYSQLD] node: Lower_case_table_names=1
3, restart MySQL can;

Where the Lower_case_table_names=1 parameter defaults to 1 in Windows, 0 in Unix, so there is no problem in window, The reason for the problem (especially when MySQL does not use uppercase letters when naming a table, and the error that the query uses the capital letter but will not be able to find it), is confusing.

MySQL table name case-Insensitive setting method