I have installed mysql v5.5.17 in linux using yum, now i want default lowercase table names so i have added
set-variable = lower_case_table_names=1
but if i do that then i could not start mysqld service. Mysql logs says unknown variable
I have also tried with
set global lower_case_table_names=1; in command line but is says its read only variable.
In 5.5 we need to specify