Created
October 20, 2013 07:30
-
-
Save sathish-io/7066039 to your computer and use it in GitHub Desktop.
MySQL_ignore_case_table_name
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| 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