Search code examples
mysqltablename

Use Mysql lower_case_table_names to 1

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

  • In 5.5 we need to specify 

    lower_case_table_names=1