How to make MySQL table name case insensitive in Ubuntu? I am using Ubuntu 13.10 and MySQL 5.6 and I know database name and table name are case sensitive in Ubuntu (and some other *nix environments) by default.

Now, I want to make MySQL work as case insensitive in Ubuntu.

Is it possible? If yes, how can I do it?
Open terminal and edit /etc/mysql/my.cnf 

sudo nano /etc/mysql/my.cnf


Underneath the [mysqld] section.add: 

lower_case_table_names = 1


Restart mysql 

sudo /etc/init.d/mysql restart


Then check it here: 

mysqladmin -u root -p variables