MySQL database in Linux system is case-sensitive by default

Today in development encountered such a problem, the connection to the database to the server (the server is a Linux system), the program has been running out of error, the total hint of the database table is not found,

and open the database to see the table clearly exists, in my impression MySQL data is not case-sensitive, and later found that the data in the Linux system is strictly the default MySQL size

Can be added to the configuration file,

After logging in with the root account, add Lower_case_table_names=1 and restart the MySQL service after [mysqld] in/etc/my.cnf, then the success is set: The case of the table name is not distinguished;

4, variable names are also strictly case-sensitive;

MySQL database in Linux system is case-sensitive by default