We were using 8.36 where, when a db is installed, default value for lower_case_table_names is always set to 1. (If value is 1, Table names are stored in lowercase on disk and name comparisons are not case-sensitive. MySQL converts all table names to lowercase on storage and lookup. This behavior also applies to database names and table aliases.). Screenshot of value in old system The problem is in new 8.4 installation, the default value is set as 0. means (0 = Table and database names are stored on disk using the lettercase specified in the CREATE TABLE or CREATE DATABASE statement. Name comparisons are case-sensitive. You should not set this variable to 0 if you are running MySQL on a system that has case-insensitive file names (such as Windows or macOS). If you force this variable to 0 with --lower-case-table-names=0 on a case-insensitive file system and access MyISAM tablenames using different lettercases, index corruption may result.) Now some queries may break if this happens. Now i have to manually reinitialize the database and change value. Screenshot in 8.4 Can you look into this ? because some of our development happens in windows and in windows its case insnsitive. So manyy places there will be missmatch. in earlier version whatever be the case, it all stores in lowercase. Wheer as with value 0, it will be case sensitive.

Critical: My SQL 8.4 default value of lower_case_table_names is set to 0.

aaPanel_Kern

Hello, you can add this directly in the configuration

aaP_hareeshnarayan1982

aaPanel_Kern
It cannot be added once the server is initialised.

Mysql Site also says the same

aaPanel_Kern

Hello, the installation script has been added to the configuration. Does it not take effect? Is this in the configuration?

aaP_hareeshnarayan1982

aaPanel_Kern

Was this added already? I will test it once again by deploying a fresh machine and will let you know.

aaP_hareeshnarayan1982

aaPanel_Kern

i had re installed on an ubuntu 24.04 and still the value remains the same 0. I had to manually add the configuration in my.cnf and reinitialize the database.

aaPanel_Kern

ok we will test it

aaP_hareeshnarayan1982

aaPanel_Kern Please note that this is for 8.4 version with compiled installation.

aaPanel_Kern

Hello, will the installation work normally if you try again?

aaP_hareeshnarayan1982

aaPanel_Kern

I tried 2 hours back and it was same. I will check once again.

aaP_hareeshnarayan1982

aaPanel_Kern

Now its back like old.

What was wrong and how did you corrected?

aaPanel_Kern

Installation script problem, configuration failed to be written successfully

aaP_hareeshnarayan1982

aaPanel_Kern

Thank you for the quick response.

mergehez

same issue here. in my case it is always set to 1

when I set it to 0 in /etc/my.cnf and reinstall mysql, the value in /etc/my.cnf is set back to 0

when I modify "/www/server/panel/install/mysql.sh" and reinstall mysql, then this file is reverted back to original.

Which means there is no way to set "lower_case_table_names" to 0

mergehez

After spending hours I finally found a workaround:

uninstall mysql in "App Store"
open /www/server/panel/install/install_soft.sh and comment this line:
# wget --no-check-certificate -O $name.sh $serverUrl/$mtype/$name.sh
open /www/server/panel/install/mysql.sh, search for lower_case_table_names and modify the value in both lines.
like: sed -i '/tmp_table_size/a\lower_case_table_names = 0' /etc/my.cnf
(Not sure whether this is needed) open /etc/my.cnf and update the value of lower_case_table_names
like: lower_case_table_names = 0
install mysql in "App Store"
Uncomment the line from Step 2