How to turn off case sensitivity for entire database

Question

I have created a database that has many scripts and many sprocs, in this db we have not paid attention to worrying about case sensitivity as it was off for my local development machine.

With all of this said, I am trying to figure out how to make the following 2 statements return the same result.

SELECT * FROM companies
SELECT * FROM Companies

Currently the lowercase one doesn't return anything and says that there isn't that table in the schema.

Answer 1

There is a variable called lower_case_table_names in my.cnf file which can be set as lower_case_table_names=1 to make the mysql table incasesensitive.

To do this in Linux below are the steps:

Open terminal and edit /etc/mysql/my.cnf

sudo nano /etc/mysql/my.cnf Underneath the [mysqld] section.add if not present in the cnf file:

lower_case_table_names = 1

Restart mysql

sudo /etc/init.d/mysql restart