You can use Alibaba Cloud Data Management Service (DMS) to maintain your database service. This topic shows you how to use DMS to log on to a database service.
Prerequisites
-
The database service has a public IP address enabled. For more information, see Enable or disable a public IP address.
-
You have set a password for the database. For more information, see Reset the database password.
Background information
Data Management Service (DMS) is an all-in-one data management platform that supports the entire data lifecycle. DMS provides capabilities such as data asset management, data governance, database design and development, data integration (including cloud migration, disaster recovery, multi-active deployment, and ETL), data development, and data consumption. DMS helps enterprises efficiently and securely extract value from data and accelerate their digital transformation. For more information, see What is Data Management Service (DMS)?.
Procedure
-
Go to the Simple Database Service page in the Simple Application Server console.
-
On the Database Service page, locate the target database service and click Logon. The Log on to Database Instance dialog box appears.
If you have multiple database services, you can find a specific one by entering its instance ID in the search box.
-
In the Log on to Database Instance dialog box, configure the following parameters.
Parameter
Description
Database type
The default value is MySQL.
Region
The system automatically selects the region of the database service.
Endpoint
The system automatically displays the public IP address of the database service.
Port
The default value is 3306.
Database account
Enter the database account. The default account for the database service is
administrator.Database password
Enter the database password. If you have not set a password for the database service, see Reset the database password.
Control mode
Select Flexible. For more information, see Control modes.
-
Click Test connection.
If the connection test is successful, a Connection successful message appears. This indicates that DMS can connect to the database service. Click OK to close the dialog box.
-
In the dialog box that appears, click OK.
-
In the Log on to Database Instance dialog box, click Logon.
After DMS successfully connects to the database service, DMS redirects you to its console where you can view and manage the database. For more information about how to use DMS, see Feature overview for standard users. The navigation pane on the left displays the instance tree of the connected database. The SQL Console window appears on the right. In the SQL editor, you can write and execute SQL statements.
-
Create a database.
By default, a new database service instance does not include any databases. You must create them manually.
-
In the instance list on the left side of the DMS console, right-click the target instance and select Database Management from the context menu.
-
Click Create Database.
-
In the Create Database dialog box, configure Database Name, Character set, and Collation.
For example, set Database name to
test, Character set toutf8, and Collation toutf8_general_ci, and click OK. -
Click OK.
-