How to solve the problem of case-sensitive parameter error caused by uppercase of mysql library name

This article introduces how to solve the problem of case sensitive parameter error caused by uppercase of mysql library name. The content is very detailed. Interested friends can use it for reference. I hope it will be helpful to you.

Lower_case_table_names

Indicates whether the table name is case-sensitive and can be modified.

When lower_case_table_names = 0, mysql operates directly according to the table name and is case-sensitive.

When lower_case_table_names = 1, mysql changes the table name to lowercase before performing the operation.

Note that there is a big problem here.

When case insensitivity is set. At this time, the name of the library is capitalized. There will be an error that the library cannot be found

This is because the setting is case-insensitive. When mysql goes to find the library, it will become a lowercase name to find it.

However, the database directory in the data directory is still uppercase at this time. The report was wrong at this time.

This is the end of how to solve the problem of case-sensitive parameter errors caused by uppercase of mysql library names. I hope the above content can be helpful to you and learn more knowledge. If you think the article is good, you can share it for more people to see.