MySQL query under Linux, library name and table name are case-insensitive

Ask for advice, Linux under MySQL query, library name and table name is not case-sensitive, how to set?

Reply content:

Ask for advice, Linux under MySQL query, library name and table name is not case-sensitive, how to set?

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;
Lower_case_table_names parameter Details:
Lower_case_table_names=0
Where 0: Case sensitive, 1: Case insensitive

Give it a try.

