This topic describes how to log on to a database instance in the Data Management (DMS) console. This topic also describes how to log on to a database instance by using another database account in the DMS console.
Prerequisites
The account used to log on to the database instance is granted the permissions on the databases and tables.
The database instance is managed in Flexible Management or Stable Change mode. For more information, see Control modes.
Procedure
Log on to a database instance in the database instance list in the DMS console
Before you log on to a database instance in the database instance list in the DMS console, make sure that your database instance is registered with DMS. For more information, see Register an Alibaba Cloud database instance.
- Log on to the DMS console V5.0.
In the left-side database instance list, find the database instance that you want to log on to and right-click the instance.
NoteDatabase instances are displayed in the Logon-free Instances, Instances Connected, and Instances Disconnected sections.
Click Login Instance.
In the Login Instance dialog box, configure the Database Account and Database Password parameters.
NoteThe Database Account parameter specifies the username of the account that is used to log on to the database instance. Do not enter the database name.
Click OK.
After you log on to the database instance, the SQLConsole tab appears. You can perform operations on the databases based on your business requirements.
Log on to a database instance after you are navigated to the DMS console in the instance console
In this example, an ApsaraDB RDS for MySQL instance is used.
On the Instances page in the ApsaraDB RDS console, find the instance to which you want to log on, and then click its name.
In the left-side navigation pane, click Accounts to view the account names.
NoteIf you forget the password of the account that you want to use, click Reset Password in the Actions column. For more information, see Reset the password of an account on an ApsaraDB RDS for MySQL instance.
In the upper part of the instance details page, click Log On to Database.
You are navigated to the DMS console. The Log on to Database Instance dialog box appears.
Configure the Database Account and Database Password parameters.
NoteThe Database Account parameter specifies the username of the account that is used to log on to the database instance. Do not enter the database name.
Click Login.
What to do next
After you log on to a database instance in DMS, you can perform the following operations based on your business requirements:
You can manage the database on the SQLConsole tab, such as creating tables in the database and querying and modifying the table data. For more information, see Manage a database on the SQLConsole tab.
Export existing data in the database. For more information, see Export databases.
Create a database. For more information, see Manage databases.
For more information about logging on to a database in the DMS console, see FAQ about database logon.