gistfile1.md

MySQL lower case table names sensitive in linux

Type in your terminal

sudo vim /etc/mysql/my.cnf

Edit the file adding the entry lower_case_table_names=1 just under the group definition: [mysqld]

lower_case_table_names=1

It will look like

[mysqld]
#
# * Basic Settings
#
lower_case_table_names=1
user            = mysql
pid-file        = /var/run/mysqld/mysqld.pid
socket          = /var/run/mysqld/mysqld.sock
port            = 3306
basedir         = /usr
datadir         = /var/lib/mysql
tmpdir          = /tmp
lc-messages-dir = /usr/share/mysql
skip-external-locking

Restart mysql

sudo service mysql restart

Enjoy!