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.

Sign up for The Ultimate MySQL Bootcamp: Go from SQL Beginner to Expert course on Udemy and learn more.

Leave a comment below if this article is outdated or inaccurate and share if you find it useful.


Written by Mohd Shakir Zakaria. Last updated on 2019-02-12