I found this:
and i try that setting in server.cnf for mariaDB and it doesn't work, lower_case_table_names is STILL 0 if I double check from UI when MariaDB is up !:
SHOW VARIABLES LIKE 'lower_case_table_names';
for the content of my server.cnf please refer to this :
when I do this inside MariaDB via UI :
error returns by saying:
Lookup Error - MySQL Database Error: Variable 'lower_case_table_names' is a read only variable
what is the problem? MariaDB seems can't see the setting in mysqlid section.
is it say it once MariaDB is installed we can't change it, what if it is a MariaDB docker ?
any doc detail how to set this setting during installation ?