Centos7 MySQL Case sensitive issue

MySQL case sensitive issues under CENTOS7 cause the program to run without finding the corresponding table.

Workaround:

The first step: Edit the/etc/my.cnf file, add the Lower_case_table_names=1 parameter under the [Mysqld] section, and set the corresponding value (Note: 0 o'clock case sensitive, 1 o'clock case insensitive, default 0).

(must be added under [mysqld] node, otherwise no effect)

Step Two: Restart MySQL

# Service Mysqld Restart

Step three: View MySQL parameters

# mysql-uroot-p

Centos7 MySQL Case sensitive issue