Difference between revisions of "Disabling case-sensitive checking for table and column names in MySQL"
From Notes_Wiki
(Created page with "=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...") |
m |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 6.x]] > [[Mariadb configuration|MariaDB configuration]] > [[Disabling case-sensitive checking for table and column names in MySQL|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 '<tt>/etc/my.cnf</tt>' and restart mysqld service. | 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 '<tt>/etc/my.cnf</tt>' and restart mysqld service. | ||
| Line 7: | Line 7: | ||
There are other MySQL variables other then this which can help in changing the behavior of MySQL. Use '<tt>show variables</tt>' command to see values of variables. We can also use 'SET GLOBAL <variable_name>=<value>;'syntax for changing values of variables on running MySQL. | There are other MySQL variables other then this which can help in changing the behavior of MySQL. Use '<tt>show variables</tt>' command to see values of variables. We can also use 'SET GLOBAL <variable_name>=<value>;'syntax for changing values of variables on running MySQL. | ||
[[Main Page|Home]] > [[CentOS]] > [[CentOS 6.x]] > [[Mariadb configuration|MariaDB configuration]] > [[Disabling case-sensitive checking for table and column names in MySQL|Disable case-sensitive checking in MySQL]] | |||
Latest revision as of 02:51, 5 March 2022
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
