Case sensitivity of mysql statements in linux

Mysql statements are case sensitive in linux. In windows, the default SQL statement is lower_case_table_name = 1 (0 is case sensitive and 1 is case insensitive), which is case insensitive. however, in linux, lower_case_table_name = 0 is case sensitive by default. To modify the mysql configuration file, follow these steps: 1. # vi/etc/my. cnf 2. Add lower_case_table_name = 1 to [mysqld], save and exit: 1. press Esc. 2. enter the colon ": wq" 3. Restart mysql/etc/init. d/mysqld restart if Warning: World-writable config file '/etc/my. cnf 'is ignored. This is only a warning and can be ignored. But the following is a solution to fix it: chmod 644/etc/my. cnf-644 indicates rw-r-and then restart the service.