# How to make database as case insensitive?

**URL:** <https://forums.percona.com/t/how-to-make-database-as-case-insensitive/8190>\
**Category:** Percona Server for MySQL 5.7\
**Tags:** community, mysql, percona\
**Created:** [October 26, 2020, 5:18am UTC](https://forums.percona.com/t/how-to-make-database-as-case-insensitive/8190 "2020-10-26T05:18:29Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![muru](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/muru/32/1432_2.png) [@muru](https://forums.percona.com/u/muru)\
**Post date:** [October 26, 2020, 5:18am UTC](https://forums.percona.com/t/how-to-make-database-as-case-insensitive/8190/1 "2020-10-26T05:18:29Z")

</div>

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!!

---

<div class="post-metadata">

**Author:** ![vaibhav\_upadhyay40](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vaibhav_upadhyay40/32/9_2.png) [@vaibhav\_upadhyay40](https://forums.percona.com/u/vaibhav_upadhyay40)\
**Post date:** [October 26, 2020, 6:01am UTC](https://forums.percona.com/t/how-to-make-database-as-case-insensitive/8190/2 "2020-10-26T06:01:14Z")

</div>

Hi @muru

please correct the typo and restart

current:

lowe\_case\_table\_name=1

change to:

lowe **r** \_case\_table\_name **s** =1

---

<div class="post-metadata">

**Author:** ![muru](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/muru/32/1432_2.png) [@muru](https://forums.percona.com/u/muru)\
**Post date:** [October 26, 2020, 10:55am UTC](https://forums.percona.com/t/how-to-make-database-as-case-insensitive/8190/3 "2020-10-26T10:55:06Z")

</div>

Thanks a lot !! It worked like Charm

---

<div class="post-metadata">

**Author:** ![vaibhav\_upadhyay40](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/vaibhav_upadhyay40/32/9_2.png) [@vaibhav\_upadhyay40](https://forums.percona.com/u/vaibhav_upadhyay40)\
**Post date:** [October 26, 2020, 12:26pm UTC](https://forums.percona.com/t/how-to-make-database-as-case-insensitive/8190/4 "2020-10-26T12:26:32Z")

</div>

Happy to know @muru ! 🙂