Setting method for MySQL table names that are case insensitive
- 2020-06-15 10:22:17
- OfStack
MySQL under Linux is case-sensitive by default. MySQL can be case-insensitive by setting the following:
1. Login with root and modify /etc/ my.cnf;
2. Add a row under [mysqld] node: lower_case_table_names=1
3. Restart MySQL;
lower_case_table_names=1 by default in Windows this option is 1, in Unix it is 0, so in window you will not encounter problems, 1 once until linux is the cause of the problem (especially in mysql table name is unable to use capital letters, but queries using capital letters will find errors, really confusing)