How to make MySQL case insensitive on Linux

Today, my colleague told me that he had run a good program locally and put it on linux, but the system prompts that the table does not exist. I can see that all the table names in the database are in lower case, but all the programs are in upper case.

Today, my colleague told me that he had run a good program locally and put it on linux, but the system prompts that the table does not exist. I can see that all the table names in the database are in lower case, but all the programs are in upper case. The reason for running locally is that windows file names are case-insensitive, but Linux files are strictly differentiated. If you want to change the program all over again, you can modify my. cnf to make it case insensitive. the modification method is as follows:

Vi/etc/my. cnf
Add a line under [mysqld:

Lower_case_table_names = 1

This statement indicates a case-insensitive table name. Restart the MySQL service.