All Products
Search
Document Center

Lindorm:Enable the MySQL compatibility feature

Last Updated:Mar 07, 2025

Before you use the MySQL protocol to access LindormTable, you must enable the MySQL compatibility feature in the Lindorm console. After you enable this feature, you can obtain the MySQL endpoint in the console for subsequent operations.

Prerequisites

The version of LindormTable is 2.6.5.2 or later. For information about how to view or update the minor version of LindormTable, see Release notes of LindormTable and Upgrade the minor engine version of a Lindorm instance.

Usage notes

The MySQL compatibility feature is automatically enabled if your LindormTable is activated after August 2024. You do not need to enable this feature in the Lindorm console.

Procedure

  1. Log on to the Lindorm console.

  2. In the upper-left corner of the page, select the region where the instance is deployed.

  3. On the Instances page, click the ID of the instance that you want to manage or click Manage in the Actions column corresponding to the instance.

  4. In the left-side navigation pane, click Database Connection.

  5. On the Wide Table Engine tab, choose MySQL Compatibility Address > Enable MySQL Compatibility.image.png

    Important

    If you enable the MySQL compatibility feature, Lindorm SQL is switched to a new architecture. This change may result in SQL syntax differences and cannot ensure full compatibility. For your instances that were purchased before September 2023, the MySQL Compatibility Address button is not displayed in the console even if the LindormTable version is upgraded to 2.6.5.2 or later.

    In this case, contact the Lindorm technical support (DingTalk ID: s0s3eg3).

  6. In the message that appears, click OK.

    Important

    When the MySQL compatibility feature is being enabled, your Lindorm instance is in the Changing Specifications state. In this case, other operations, such as service activation and specification upgrade or downgrade, cannot be performed on the instance. To use the instance as usual, you can wait 2 to 10 minutes until the instance changes to the Running state.