Lowercase Table Names in MySQL
Jump to navigation
Jump to search
Start mysqld with -0 lower_case_table_names=1. By default this option is 1 on Windows and 0 on Unix.
The MySQL configuration file is my.ini. It's typically located in the Windows system directory (e.g. C:\WINNT\my.ini).
For case-sensitive table names to be the default MySQL option add this line to the my.ini file:
set-variable=lower_case_table_names=0
All the set-variable directives can be set this way.