Share via

Set lower_case_table_name parameter to 0 on MySQL Azure

Samuel Caitano Souza 20 Reputation points
2025-04-28T18:12:48.4133333+00:00

Hello,

I'm deploy an application that use MySQL database and i decided use the Azure Database for MySQL. However, the parameter lower_case_table_name is set 1 to default and i can't change this. I try create another database and set the value 0 at the moment of the creation and the option isn't appear. After the creation, again, the dropdown option are disable.

I can change this? How do this? I need set the value to 0 because my app use some table in case sensitive.

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
949 questions
Accepted answer
  1. Azar 28,000 Reputation points MVP
    2025-04-28T18:18:52.8333333+00:00

    Hi there Samuel Caitano Souza

    Thanks for using QandA platform

    the lower_case_table_names parameter is set to 1 by default and cannot be changed. because Azure MySQL runs on Linux-based systems where case sensitivity is handled differently, and modifying this setting would cause storage issues.

    If your application requires lower_case_table_names=0 , you will need to either:

    Host MySQL yourself on a VM where you can control the server settings, or

    • Adjust your application to work with case-insensitive table names .

    Unfortunately, Azure’s managed MySQL does not allow changing lower_case_table_names due to platform restrictions

    If this helps kindly accept the answer thanks much.

    1 person found this answer helpful.
    0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.