MySQL table names are case-insensitive on Linux

A php program is downloaded and runs normally on Windows. However, when running on Linux, the system prompts that the table does not exist.

It turns out that MySQL is not case sensitive in Windows, so it is normal. However, in Linux, because MySQL is case-sensitive by default, an error occurs in the program.

The simplest way is to modify the MySQL configuration file on Linux, Which is 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 and try again.

This is the easiest way to modify it. However, this method may not be very scientific. We recommend that you write a program in detail and make sure it is case sensitive.

Yes! The rule is king.