Disabling case-sensitive checking for table and column names in MySQL
From Notes_Wiki
Home > CentOS > CentOS 6.x > MariaDB configuration > Disable case-sensitive checking in MySQL
On Operating Systems like Windows where filesystem is case-insensitive MySQL would be case-insensitive by default. But on operating systems like Linux MySQL is case-sensitive. To disable case-sensitivity in Linux we can add following line in '/etc/my.cnf' and restart mysqld service.
lower_case_table_names=0
There are other MySQL variables other then this which can help in changing the behavior of MySQL. Use 'show variables' command to see values of variables. We can also use 'SET GLOBAL <variable_name>=<value>;'syntax for changing values of variables on running MySQL.
Home > CentOS > CentOS 6.x > MariaDB configuration > Disable case-sensitive checking in MySQL
