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

Get In Touch

We would love to hear from you.

Please enter your email address.
Please enter a valid email address.
Please enter a message.
Please check your message for any errors.
Your message has been sent successfully.
Sorry, an error occured sending your message.
* required