Mysql case sensitivity question _ MySQL

Mysql case-sensitivity issues when I was working on enterprise projects, I used oracle databases and mysql for new company projects.

1 in windows, mysql is case-insensitive by default. to make mysql case-insensitive. Change Method

Find the my. ini file in the mysql installation directory and add the following at the end of the file:

Lower_case_table_names = 0

Restart the mysql service.

2 In linux, the configuration file is case-sensitive by default and can be modified.

Log on to the root account and modify/etc/my. cnf or/etc/mysql/my. cnf.

Lower_case_table_names = 1 # case insensitive

Lower_case_table_names = 0 # case sensitive

Restart mysql service

/Etc/init. d/mysql restart

Note:

If my cannot be found in/etc or/etc/mysql. for cnf, you need to find it under/usr/share/mysql *. copy one of the cnf files to/etc/and change it to my. cnf and put it under/etc.
Cp/usr/share/mysql/my-*. cnf/etc/my. cnf