How to make database as case insensitive?

[muru]

Hi,

I have added the below property in mysqld.cnf file to make mysql db as case insensitive. After i added the property i am not able to connect the database.I have done restart of mysql service after changing the property.

lowe_case_table_name=1

Seems something went wrong. Please assist!!

[vaibhav_upadhyay40]

Hi @muru

please correct the typo and restart

current:

lowe_case_table_name=1

change to:

lower_case_table_names=1

[muru]

Thanks a lot !! It worked like Charm

[vaibhav_upadhyay40]

Happy to know @muru !