Monday 11 March 2013

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.....

also use below method for disable case-sensitivity (using startup command)

 

No comments:

Post a Comment