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)


Related articles: