I have installed
MySql Workbench 6.2
MySql version 5.6
The server is configured with lower_case_table_names=1 which only
allows lowercase characters in schema and table names.
# *** DO NOT EDIT THIS FILE. It's a template which will be copied to the
# *** default location during install, and will be replaced if you
# *** upgrade to a newer version of MySQL.
In Windows, table naming is case-insensitive. That is, your
Customer table and your
customer table will always be the same on Windows. That's a limitation of the NT File System.
(You can use mixed-case table names for different tables on Linux, BSD, and the like, but it's considered very bad practice: only do that if you want to drive your colleagues crazy. So be careful.)
If you leave this
lower_case_table_names setting alone, you can use mixed case in your table names without problems.
my.ini file the server actually uses when it starts is usually found in the
data directory. The installation procedure can copy a preloaded version of that file, like
my_large.ini on top of
my.ini depending on what you are trying to do.