Geek Answers Handbook

Lower_case_table_name Error

I am trying to set lower_case_table_name to 2 since this is a windows server. But when I start MySQL Workbench and connect to my server, I get the following error:

The server is on a system that does not properly support the selected lower_case_table_names parameter value.

Should a Windows server support a value of 2 ? I am running MySQL 5.6 on Windows Server 2012 and using MySQL Workbench 6.3.

+7
mysql windows-server mysql-workbench
source share
2 answers

You can safely ignore this error.

I recently installed MySQL on a new Windows computer and got this error, and after setting lower_case_table_names to 2 . I do not remember this before. However, despite the error, it seems that it is working correctly. Tables are created using the right case, and I can do case insensitive searches.

+2
source share

Changing the value to lower_case_table_names = 1 prevents the warning. The default is Windows 1. To set this variable, see: https://dev.mysql.com/doc/refman/8.0/en/identifier-case-sensitivity.html.

0
source share

More articles:


All Articles