Connect to a SelectDB instance using DMS - ApsaraDB for SelectDB

ApsaraDB for SelectDB supports connection over the MySQL protocol. You can connect using tools compatible with the MySQL ecosystem, such as command-line tools, JDBC/ODBC drivers, or visualization tools. Data Management (DMS) is a GUI-based data management tool from Alibaba Cloud that lets you manage relational databases and NoSQL databases — with features including data management, SQL operations, data import/export, database clone, performance optimization, and security audit — all without switching to a separate tool. This topic describes how to connect to an ApsaraDB for SelectDB instance through DMS directly from the SelectDB console.

Prerequisites

Before you begin, ensure that you have:

An ApsaraDB for SelectDB instance. See Create an ApsaraDB for SelectDB instance.
The admin password for the instance. See Reset the admin password.
The DMS server IP addresses added to the instance whitelist — DMS cannot establish a network connection unless its IPs are allowed. See DMS IP addresses and CIDR blocks for the IP list, and Configure an IP address whitelist for how to add them.

When you log in, have your Database Account and Database Password ready. All other parameters in the login dialog box are pre-filled from the current instance.

Log in to DMS

Log on to the ApsaraDB for SelectDB console.
In the top navigation bar, select the region where the instance resides.
In the left-side navigation pane, click Instances. Find the instance and click its instance ID to open the Instance Details page.
On the Instance Details page, click Log on to DMS in the upper-right corner.

In the dialog box that appears, enter your Database Account and Database Password. Most other parameters are pre-filled from the current instance — review the table below if you need to change any of them.

Parameter	Description
Database type	Fixed to SelectDB. Do not modify.
Instance region	Pre-filled with the current instance's region. To log on to an instance in a different region, select it from the drop-down list in the DMS console instead.
Instance ID	Pre-filled with the current instance ID. To log on to a different instance, select its ID from the drop-down list.
Database account	The account used to log on to the instance.
Database password	The password for the database account.
Remember password	Select this option to have DMS automatically fill in your account and password on future logins — you will not need to enter them again.
Control mode	The mode DMS uses to manage the instance. Valid values: Flexible Management, Stable Change, Secure Collaboration. Defaults to Stable Change on first login. See Control modes. To change the control mode after logging in, see Modify database instances.

Note

Tip: Before logging in, click Test Connection in the lower-left corner to verify connectivity. If the test fails, check the instance information based on the error message.

Click Login.

After logging in, double-click a database name in the left-side navigation pane to open its SQL Console and start running SQL statements. See Create a database and write data to the database for next steps.

FAQ

What do I do if a whitelist error appears when registering an ApsaraDB for SelectDB instance with DMS?

Configure whitelist dialog

Click Configure whitelist in the dialog box. DMS automatically adds its server IP to the instance whitelist. If the automatic update fails, add the IP manually. See Configure an IP address whitelist.