It seems that from mysql 8 and mariadb 10.2 on this setting can not be changed easily.
when I set lower_case_table_names=2 in my.cnf it gives errors and mysql won’t start.
Then I red that it can only be configured when initializing the server. Changing the lower_case_table_names setting after the server is initialized is prohibited.
removed all and reinitialized mariadb but nothing works with the newer version on Linux.
It always comes up with: mysql: unknown variable ‘lower_case_table_names=2’
Although I learned a lot. I have to give up and I will setup a new fresh database and start brand new.
This is way above my head, I am reading lot’s of people with newer Mysql/mariadb versions having trouble Changing the lower_case_table_names setting.
Thank you for all your work !
Recent Comments