Case-insensitive MySQL table name settings _ MySQL

MySQL table names are case-insensitive. by default, MySQL in Linux is case-sensitive. the following settings enable MySQL to make table names case-insensitive:
1. log on with root and modify/etc/my. cnf;
2. add a row under the [mysqld] Node: lower_case_table_names = 1
3. restart MySQL;

The lower_case_table_names = 1 parameter is set to 1 by default in Windows and 0 in Unix. Therefore, this parameter is not encountered in Windows, the cause of the problem persists in linux (especially when mysql naming a table, it cannot contain uppercase letters, but the query cannot contain uppercase letters, it's confusing)