How to use case-insensitive table name for MySQL in Linux

Files and folders in Linux and Unix in general are case sensitive. This also makes MySQL table names to be case sensitive, which is not so in Windows. Follow these steps to use case-insensitive table name for MySQL in Linux or Unix in general;

  1. Open MySQL configuration file using your favorite editor.
  2. Set lower_case_table_names to 1. Add the line if the option does not already exist in the configuration file.
    lower_case_table_names=1
  3. Restart MySQL service.