Skip to content

Instantly share code, notes, and snippets.

@laszlomiklosik

laszlomiklosik/mysql case sensitivity disabling

Created March 21, 2014 08:25
Show Gist options
  • Save laszlomiklosik/9681937 to your computer and use it in GitHub Desktop.
Save laszlomiklosik/9681937 to your computer and use it in GitHub Desktop.
Download ZIP
mysql case sensitivity disabling
Raw
mysql case sensitivity disabling
# if you want queries executed in all you schemas to be case insensitive do this
$ sudo gedit /etc/mysql/my.cnf
edit the file adding the entry lower_case_table_names=1 just under the group definition: [mysqld]
[mysqld]
lower_case_table_names=1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment