My Windows environment configuration mysql5.6 configuration file. The ini
Under the mysqld columns add lower_case_table_names=0
Mysql cannot be started,
The Windows event monitor prompt
The server option 'lower_case_table_names is configured to use case sensitive table names but The data directory is on a case insensitive file system which is an unsupported combination. Both Please consider either using a case sensitive file system for data directory or switching to a case - insensitive table name mode.

Translation:
Server option "lower_case_table_names" is configured to use case-sensitive name of the table, but the data directory is case sensitive file system, does not support the combination, please consider using a sensitive switch for your data directory or file system to a table name is not sensitive to model,

Instead of
Lower_case_table_names=1 or deleted this sentence can normal boot ~!! Urgent urgent rookie inquired what reason is this

CodePudding user response:

Case sensitive to operating system support, case-insensitive Windows itself, so you cannot set this one,

CodePudding user response:

Both Please consider either using a case sensitive file system for data directory or switching to a case - insensitive table name mode
Please consider using a sensitive switch for your data directory or file system to a table name is not sensitive to model,
Windows itself case-insensitive consider using Linux

CodePudding user response:

This can't literally change, it is because the mysql table is stored as a file, and you then modified, is to distinguish the case file name,
The original file name is TB, now if you write TB, direct error,

CodePudding user response:

Windows to case-sensitive set to 2
Look from the website of http://dev.mysql.com/doc/refman/5.6/en/identifier-case-sensitivity.html

CodePudding user response:

This combination is not supported, because Windows is unable to be case-sensitive, Mysql also unable to change the characteristics of file system, so suggest you:

This server option "lower_case_table_names' is configured to distinguish between the table name case, but the data directory is not case sensitive file system, is the combination of does not support, please consider using can make your data directory case sensitive file system, or switch to distinguish the table name case model,

CodePudding user response:

Set to 1, why is set to 0?

CodePudding user response:

Lower_case_table_names=2, mysql 5.6 above the set value of 2, case-sensitive, 1 does not distinguish between

CodePudding user response:

The meaning of your translation clear
Website document for this parameter isn't clear that if it can be set to 0
You should not set lower_case_table_names to 0 if you are running MySQL on a system where the data directory resides on a case insensitive file system (to as on Windows or OS X). It is an unsupported combination that could result in a hang condition when running an INSERT INTO... The SELECT... The FROM tbl_name operation have the wrong tbl_name letter case. With MyISAM, accessing the table names using company letter cases could cause index corruption. The