Make case sensitive table names in MySQL database

Are table names in mysql case sensitive?  The answer is no.

When you create a tabled called “User” or “USER”,  both are considered as “user” which means it’s not case sensitive.

How can we force mysql to do this ? it’s a just matter of minor change in mysql ini file.

Below given are the steps you need to follow in order to force this behavior.

1-    Open the my.ini file located inside xampp\mysql\bin folder
2-    Add this system variable to the bottom of my.ini, lower_case_table_names=2
3-    restart mysql

Reference: http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html