How to make database as case insensitive?

muru · December 30, 2020, 4:26pm

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 · December 30, 2020, 4:37pm

Hi @muru

please correct the typo and restart

current:

lowe_case_table_name=1

change to:

lower_case_table_names=1

muru · December 30, 2020, 4:37pm

Thanks a lot !! It worked like Charm

vaibhav_upadhyay40 · December 30, 2020, 4:37pm

Happy to know @muru !