Answer the question
In order to leave comments, you need to log in
Why does the database not start when setting the lower_case_table_names settings?
How to set strict case for database in xamp?
I found an answer where it was necessary to add under [mysqld] in the my.ini file lower_case_table_names = 0
, but after adding the database it does not want to start, although if you specify lower_case_table_names = 2
it, it works.
Initially, this line lower_case_table_names
is not there at all.
[mysqld]
port= 3306
Много настроек...
log_error = "mysql_error.log"
lower_case_table_names = 0
Answer the question
In order to leave comments, you need to log in
On Windows the default value is 1. On macOS, the default value is 2. On Linux, a value of 2 is not supported; the server forces the value to 0 instead.
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 (such as on Windows or macOS).
It is prohibited to start the server with a lower_case_table_names setting that is different from the setting used when the server was initialized.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question