MySQL table names in linux default case sensitivity causes the table to not find problems

Days to migrate the Windows project to Linux, and then log on to the user table can not find the error message.

Check that the name of the table in the discovery database is M_user, and then remembered that it was a case.

Find the cause of the problem and the solution is as follows:

Modify the/ETC/MY.CNF, add a line under [Mysqld], and then restart the MySQL database.

Service MySQL Stop

Service MySQL Start

# set MySQL table name is case insensitive
Lower_case_table_names=1

MySQL table names in linux default case sensitivity causes the table to not find problems