Case sensitive table names for MySQL

Change the default MySQL to Case Sensitive

Add this to the bottom of your my.ini file (located in your mysql folder/directory) to make your table names case sensitive.

Windows my.ini file can be found in c:\windows\my.ini or c:\my.ini

[mysqld]
lower_case_table_names=2

You can check if the value is set by entering this SQL statement

select @@lower_case_table_names;

 

Visit sunny St. George, Utah, USA