Use Mysql lower_case_table_names to 1

Question

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

in /etc/my.cnf

but if i do that then i could not start mysqld service. Mysql logs says unknown variable lower_case_table_names. I have also tried with set global lower_case_table_names=1; in command line but is says its read only variable.

any suggestion?

Solution 1

In 5.5 we need to specify

lower_case_table_names=1

Solution 2

my OP system is ubuntu, Mysql version is 5.5.*

update file /etc/mysql/my.cnf, (must add under the section [mysqld])

[mysqld]

lower_case_table_names=1

then restart mysql