Menu
I have a problem with changing lower_case_table_names variable value in MySQL 5.6 ... I did all that says in Where to change the value of lower_case_table_names=2 on windows xampp.
The default value on my Windows 7 is '1'. I want to switch it to '2'.
Tried several ways, what I did is:
Now, when I read "SELECT @@lower_case_table_names" it still says 1, and my db behaves like it is 1...
Any ideas?
843
On the sidebar, under the "Instance" section, click on "Options File" 4. Under the "General" tab locate the "lower_case_table_names" option (it should begin unchecked). 5. Check that option and in the text field put "2".
The only time you are allowed to change the setting of lower_case_table_names is in connection with initializing the MySQL data directory (mysqld –initialize). So you need to create a logical backup, then completely re-initialize MySQL, then restore the backup.
Use lower_case_table_names=0 on Unix and lower_case_table_names=2 on Windows. This preserves the lettercase of database and table names. The disadvantage of this is that you must ensure that your statements always refer to your database and table names with the correct lettercase on Windows.
I solved this with a file I found under
C:\ProgramData\MySQL\MySQL Server 5.6\my.ini
So, it was ProgramData, not Program Files. I got this path from MySQL Workbench -> Manage Server Instances -> [tab] System Profile -> Configuration File. Guess this is the place where one should look for the current config filepath.
98
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
