Mysql ignores case in linux environment
Mysql ignores case in linux environment
Mysql database ignores case by default in window environment, but on the contrary in linux environment, the normal use of application engineering may be affected after database migration.
Solution:
After logging in with your root account, add lower_case_table_names=1 after "mysqld] in / etc/my.cnf, and restart the MYSQL service (/ etc/init.d/mysqld restart). At this time, the setting is successful: table names are not case-sensitive.
Detailed description of lower_case_table_names parameters:
Lower_case_table_names = 0
Where 0: case sensitive, 1: case insensitive
