XAMPP MySQL lower_case_table_names=2 works until MySQL restart
<p>I'm having an issue with changing MySQL <code>lower_case_table_names=2</code> (I  have also tried changing this to 0 but hasn't made any difference) on Windows 10 XAMPP.</p>

<p>I have some tables that need to have upper-case names, so set lower_case_table_names to 2 in my.ini under [mysqld]. I then set up my database (e.g. Accounts), then my tables (e.g. Users) and all works fine. However if I restart the MySQL server, open the database and table and I get the following error: </p>

<pre><code>1146 - Table 'accounts.users' doesn't exist
</code></pre>

<p><strong>Note:</strong> the conversion to lower-case in the message.</p>

<p>Do I need to change any other settings anywhere?</p>

<p>I am using MySQL 5.6.21.</p>