T
T
Torento203452021-05-08 17:15:51
MySQL
Torento20345, 2021-05-08 17:15:51

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 = 2it, it works.
Initially, this line lower_case_table_namesis 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

1 answer(s)
R
Rsa97, 2021-05-08
@Torento20345

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 question

Ask a Question

731 491 924 answers to any question