10

I'm trying to set the lower_case_table_name value to 2, since it is a Windows server. But when I start MySQL Workbench and connect to my server I get the following error:

A server is in a system that does not properly support the selected lower_case_table_names option value.

Shouldn't a Windows server support a value of 2? I'm running MySQL 5.6 on Windows Server 2012 and using MySQL Workbench 6.3.

reuben
  • 3,360
  • 23
  • 28
Bernie Hunt
  • 306
  • 4
  • 22
  • possible duplicate : http://stackoverflow.com/questions/8550789/where-to-change-the-value-of-lower-case-table-names-2-on-windows-xampp – Tharif Mar 22 '15 at 06:31
  • I think this is related to the fact that on Windows, file names are case insensitive. Nevertheless, you can still set this option in my.ini. – Lorenz Meyer Mar 22 '15 at 06:42
  • The value is already set to 2, according to the Server Variables in the Workbench. I have already restarted the service. So the comment about possible duplcate is not valid. I did everything that other answers said and it did not solve my issue. mySQL Workbench says the value is set. but I still get the error. – Bernie Hunt Mar 22 '15 at 17:44
  • 2
    This bug is still present in latest version of MySQL Workbench (v 8.0.15). I'm writing this in 2019, 4 years after this was reported here for the 1st time. – Alexis Pautrot Mar 07 '19 at 06:46

2 Answers2

8

You can safely ignore this error.

I recently installed MySQL on a new Windows computer and got this error as well after setting lower_case_table_names to 2. I don't remember seeing it previously. However, despite the error it seems to be working properly..tables are created with the proper case and I can do case-insensitive lookups.

Samuel Neff
  • 73,278
  • 17
  • 138
  • 182
  • 2
    I can confirm Samuel's statement. I got this message too, but all seemed to work properly – Mike Dee Oct 06 '17 at 23:05
  • 2
    I got the same error...ignored it...case sensitivity honored and all is good. – HerrimanCoder Nov 17 '17 at 14:52
  • Yes, it's just a warning message of mysql workbench. It works, But pay attention when writing TableName. When you test on windows with lower case tablename. it may raise error on linux. – maoanz Dec 20 '18 at 15:49
  • A few years later (2022 now) but I'm trying to do exactly this, starting MySQLWorkbench and trying to connect to the db, which has the value set to 2. In my case it's a MariaDB and after clicking on the error-dialogue the Workbench is gone, crashed. – Sundancer Jun 10 '22 at 16:33
-1

Changing the value to lower_case_table_names = 1 prevents the warning. The windows default is 1. For the setting of this variable see: https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html

Jeremy Demers
  • 92
  • 6