Skip to content

Instantly share code, notes, and snippets.

@sathish-io
Created October 20, 2013 07:30
Show Gist options
  • Save sathish-io/7066039 to your computer and use it in GitHub Desktop.
Save sathish-io/7066039 to your computer and use it in GitHub Desktop.
MySQL_ignore_case_table_name
MySQL Table names in Linux is case sensitive.
To disable it, set property lower_case_table_names=1 in /etc/my.cnf file under "[mysqld]" section, as shown below,
==================
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
lower_case_table_names=1
==================
Other possible values for 'lower_case_table_names',
If set to 0, table names are stored as specified and comparisons are case sensitive.
If set to 1, table names are stored in lowercase on disk and comparisons are not case sensitive.
If set to 2, table names are stored as given but compared in lowercase.
Reference url -
http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html#sysvar_lower_case_table_names
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment