MySQL Modify configuration is case-sensitive

When using MySQL, the database name, table name, field name and so on are case-sensitive, this can be set through the configuration file. If you set a strict case sensitivity, you do not notice the case of the table name when you access the table, and you will be presented with an error that the table does not exist. Here's how to modify the configuration file:

Modify the My.ini file under the MySQL server installation directory by adding the following line under the Mysqld section set-variable=lower_case_table_names=0 (0: Case sensitive ; 1: Case insensitive) Finally, restart the MySQL service. My.ini files are generally in this path:/ETC/MY.CNF

MySQL Modify configuration is case-sensitive