Self-managed databases on Elastic Compute Service (ECS) instances are databases that are installed and configured on ECS instances. You can use Data Management Service (DMS) to manage self-managed databases on ECS instances. This article describes how to use DMS to add and manage self-managed databases on ECS instances. In the example, a MySQL database is used.
Note: By default, MySQL databases do not allow remote access from the root account. If you have changed the default settings to allow remote access from the root account, skip this step.
In this example, run the following command to create an account named dms for logging on to the MySQL database, set the password to Ecs123!
, and grant all permissions to the account:
create user 'dms'@'%' IDENTIFIED BY 'Ecs123!';
grant all privileges on *.* to 'dms'@'%' with grant option;
flush privileges;
DMS is a database management web terminal provided by Alibaba Cloud to help manage self-managed databases on ECS instances that run Windows or Linux. You can add self-managed databases in the DMS console to use data management features such as creating databases and tables. DMS supports self-managed MySQL, SQL Server, PostgreSQL, MongoDB, and Redis databases. For more information, see DMS documentation.
The following table describes the parameters.
Parameter | Description |
Data Source | Select ECS Self-built. |
Database Type | The type of the self-managed database on the ECS instance. In this example, select MySQL. |
Instance Region | The region where the ECS instance is located. |
ECSInstance ID | The ID of the ECS instance. |
Port | The number of the listening port used to access the database on the ECS instance. In this example, set Port to 3306. |
Database Account | The account used to log on to the self-managed database on the ECS instance. In this example, the account used to log on to the MySQL database is dms .Note: We recommend that you use a non-root account. |
Database password | The password used to log on to the self-managed database on the ECS instance. In this example, the password of dms is Ecs123! . |
Control Mode | In this example, select Flexible Management. For more information about the control mode, see Control modes. |
After you log on to the database, you can perform operations on the database by using SQL statements or the DMS console.
1,029 posts | 252 followers
FollowYen Sheng - April 3, 2023
Alibaba Clouder - February 13, 2019
Alibaba Cloud Native - November 6, 2024
Alibaba Cloud Native - March 6, 2024
Alibaba Cloud Community - March 16, 2022
ApsaraDB - November 5, 2024
1,029 posts | 252 followers
FollowElastic and secure virtual cloud servers to cater all your cloud hosting needs.
Learn MoreAlibaba Cloud Function Compute is a fully-managed event-driven compute service. It allows you to focus on writing and uploading code without the need to manage infrastructure such as servers.
Learn MoreHigh Performance Computing (HPC) and AI technology helps scientific research institutions to perform viral gene sequencing, conduct new drug research and development, and shorten the research and development cycle.
Learn MoreAlibaba Cloud PolarDB for MySQL is a cloud-native relational database service 100% compatible with MySQL.
Learn MoreMore Posts by Alibaba Cloud Community