MySQL and Windows 10, I receive an error "The server is configured with lower_case_table_names=1..."
<p>I am using MySQL Server 5.7 and MySQL Workbench 6.3 CE on Windows 10. I have sifted through several pages of questions related to this on multiple websites, including Stack Overflow, but cannot figure out where I can amend the server so that it is is configured with lower_case_table_names=2, rather than lower_case_table_names=1.</p>

<p>Many answers I have seen point to finding either a file ending in 'my.ini' or 'my.cnf', neither of which I can locate on my disc. Truthfully speaking, I am a beginner with SQL, and had difficulty understanding the tutorial page that many users have pointed to, which is:</p>

<p><a href="http://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html" rel="nofollow">http://dev.mysql.com/doc/refman/5.7/en/identifier-case-sensitivity.html</a></p>

<p>Virtually every resource I am learning from references uppercase table names, columns, etc., which is why I want to use uppercase versus lowercase.</p>

<p>For example, if I create a table called <strong>EmployeeInfo</strong> and a few columns, I get this error when I click "Apply":</p>

<pre><code>Apply Changes to Object

The server is configured with lower_case_table_names=1, which only allows lowercase characters in schema and table names. The object will be created as 'employeeinfo'.
</code></pre>

<p>I want the table to be called <strong>EmployeeInfo</strong>. I do not want it to be in lowercase. However, I cannot locate the supposed 'my.ini', or 'my.cnf' files that have been mentioned in other answers pertaining to this question.</p>

<p>Or is it a best practice to get used to using lowercase font as you move further with SQL?</p>

<p><strong>EDIT:</strong></p>

<p>I believe I have located the so-called 'my.ini' file, although, there is no 'ini' file type. It is labeled 'Configuration settings'.</p>

<p>However, I cannot find anything related to 'lower_case_table_name=1' inside after searching.</p>

<p><strong>EDIT 2:</strong></p>

<p>I found the 'lower_case_table_names' option in the System Options File and changed it to '2'.</p>

<p>However, when I click 'Apply', it tells me:</p>

<p><strong>Could not Save Configuration File</strong></p>

<p>The error looks like this:</p>

<p><a href="http://i.stack.imgur.com/zwryL.png" rel="nofollow">Error</a></p>