This topic describes how to log on to an ApsaraDB RDS for MySQL instance by using Data Management (DMS).
Prerequisites
An Alibaba Cloud account or a RAM user that has relevant permissions on your RDS instance is prepared. For more information about how to obtain permissions, see Create a RAM role for a trusted Alibaba Cloud account.
Background information
DMS offers an integrated solution that supports data management, schema management, server management, user authorization, security audit, trend analysis, data tracking, business intelligence (BI) reporting, and performance analysis and optimization.
Procedure
Go to the Instances page. In the top navigation bar, select the region in which the RDS instance resides. Then, find the RDS instance and click the ID of the instance.
In the upper-right corner of the page that appears, click Log On to Database to go to the DMS console.
In the RDS database logon dialog box, enter the username and password of the account that is used for the logon and click Login.
NoteThe account used for the logon must have permissions on the required database. Otherwise, the required database is not displayed in the left-side navigation pane. For more information about how to modify the permissions of an account, see Modify account permissions.
For more information about how to create an account, see Create an account.
Refresh the page after you log on to the database. In the left-side navigation pane, expand Instances Connected. Then, double-click the name of the RDS instance.
In the DMS console, you can switch the current database only by double-clicking the destination database but not running the
USE
command.If you cannot find the required database in an existing instance, the issue may be caused by the following reasons:
Your account does not have permissions to access the required database. You can go to the Accounts page of the RDS instance details page to manually modify the permissions of the account.
The metadata of the database is not synchronized to DMS. To find the required database, move the pointer over the RDS instance to which the required database belongs and click the
icon next to the instance name.
To quickly synchronize the schemas of a database to DMS, use the empty database initialization feature provided by DMS.
You can directly log on to the DMS console and add your RDS instance to DMS. Then, you can switch to the specified database of your RDS instance in the DMS console. For more information, see Register an ApsaraDB instance.
After you reset the password of your account, you must log on to DMS again.