Help Center/ Relational Database Service_RDS for MySQL/ FAQs/ Database Parameter Modification/ How Do I Set Case Sensitivity for RDS for MySQL Table Names?
Updated on 2025-08-20 GMT+08:00
View PDF
Share

How Do I Set Case Sensitivity for RDS for MySQL Table Names?

You can use either of the following methods to set the case sensitivity:

Modifying the Parameter for Created DB Instances

  • Before changing the case sensitivity, ensure that each table name is unique in your instance.
  • You can change the case sensitivity of table names only when there is no replication delay. To check the replication delay, view the Real-Time Replication Delay metric on the Cloud Eye console.
  • For community version 8.0, lower_case_table_names can only be configured during server initialization. Changing the lower_case_table_names setting after the server is initialized is prohibited. For details, see the community documentation.
  • Scenario 1: If the DB instance does not have read replicas, modify the parameter of the DB instance and then reboot the DB instance.
    1. Log in to the management console.
    2. Click in the upper left corner and select a region.
    3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
    4. On the Instances page, click the target instance name to go to the Overview page.
    5. In the navigation pane, choose Parameters. On the displayed page, change the value of lower_case_table_names.

      For example, change the value from 1 to 0, indicating that table names are case sensitive.

    6. Click Save. In the displayed dialog box, click Yes.
    7. Return to the DB instance list, locate the DB instance, and choose More > Reboot in the Operation column.
    8. In the displayed dialog box, click OK to reboot the DB instance for the modification to take effect.
  • Scenario 2: If the DB instance has a read replica, first modify the parameter of the read replica, reboot the DB instance, then modify the parameter of the DB instance, and reboot the DB instance again.
    1. Log in to the management console.
    2. Click in the upper left corner and select a region.
    3. Click in the upper left corner of the page and choose Databases > Relational Database Service.
    4. On the Instances page, click and then click the target read replica name to go to the Overview page.
    5. In the navigation pane, choose Parameters. On the displayed page, change the value of lower_case_table_names.

      For example, change the value from 1 to 0, indicating that table names are case sensitive.

    6. Click Save. In the displayed dialog box, click Yes.
    7. Return to the DB instance list, locate the primary DB instance, and choose More > Reboot in the Operation column.
    8. In the displayed dialog box, click OK to reboot the DB instance for the modification to take effect.
    9. On the Instances page, click the primary instance name to go to the Overview page.
    10. In the navigation pane, choose Parameters. On the displayed page, change the value of lower_case_table_names.

      For example, change the value from 1 to 0, indicating that table names are case sensitive.

    11. Click Save. In the displayed dialog box, click Yes.
    12. Return to the DB instance list, locate the primary instance, and choose More > Reboot in the Operation column.
    13. In the displayed dialog box, click OK to reboot the DB instance for the modification to take effect.

Specifying Case Sensitivity During Instance Creation

  • Set Table Name to Case sensitive or Case insensitive on the RDS console during instance creation. For details, see Buying an RDS for MySQL DB Instance.
  • Set parameter lower_case_table_names to 0 or 1 when calling an API to create a DB instance. For details, see Creating a DB Instance.
    Value range:
    • 0: Table names are case sensitive.
    • 1: Table names are stored in lowercase and are case insensitive.
Parent Topic: Database Parameter Modification