Change the MySQL database case-insensitive table name

Today depressed dead, in the Linux downgrade a program old said can't find the table, but I obviously built a table, under the command line of MySQL can also find, why the program can't find the table?

Later asked a teacher to take care of, the original is the Linux MySQL default is to distinguish the table name case, hey, get so old, killed me.

The way that MySQL does not differentiate between table name capitalization is actually simple:

1. Log in with root, modify/ETC/MY.CNF

2. Add a line under [mysqld]: Lower_case_table_names=1

3. Restart the database to