9

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,280
  • 21
  • 28
Bernie Hunt
  • 251
  • 2
  • 17
  • 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

6

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
  • 67,422
  • 16
  • 123
  • 169
  • 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
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
  • 96
  • 6