Mysql query under Linux, library name and table name are not case sensitive

Please tell me, for mysql query under Linux, the library name and table name are not case-sensitive. How to set it?

Reply content:

Please tell me, for mysql query under Linux, the library name and table name are not case-sensitive. How to set it?

After logging in with the root account, add lower_case_table_names=1 after [mysqld] in /etc/my.cnf, restart the MYSQL service, and the setting is successful: the table name is case-insensitive;
Detailed explanation of the lower_case_table_names parameter:
lower_case_table_names=0
where 0: case sensitive, 1: not case sensitive

Try this