How to Connect to an ApsaraDB RDS for MySQL Instance

MySQL is one of the most popular open-source databases in the world. As a key component of the open-source software bundle LAMP (Linux, Apache, MySQL, and Perl/PHP/Python), MySQL has been widely applied to different scenarios.

Connect to an ApsaraDB RDS for MySQL instance

After you create an RDS instance, configure a whitelist, and create an account, you can use Data Management (DMS) or a database client to connect to the RDS instance. You can also configure the endpoints, ports, and account information in your application.

DMS is a graphical user interface (GUI) provided by Alibaba Cloud for you to manage databases. It can be used to manage relational and non-relational databases. It offers various functions, such as data and schema management, user authorization, security audit, data trends, data tracking, BI charts, and performance and optimization.

Use a client to connect to an RDS instance

ApsaraDB RDS for MySQL is fully compatible with open source MySQL. You can connect to an ApsaraDB RDS for MySQL instance from a database client by using a similar method that you use to connect to an open source MySQL database. In the following example, the HeidiSQL client is used.

1. Start the HeidiSQL client.
2. In the lower-left corner of the Session manager dialog box, click New.
3. Enter information about the RDS instance that you want to connect. The following table describes the required parameters

4. Click Open

If the connection information is correct, the RDS instance is connected.

Benefits of Using ApsaraDB RDS for MySQL

AliSQL

Alibaba Cloud has polished AliSQL for more than five years and released over 300 patches to make AliSQL more competent in processing highly concurrent requests. In addition, Alibaba Cloud has introduced features such as thread pool, parallel replication, and implicit primary key to increase IOPS and make your database instances more stable.

Security certificates

ApsaraDB RDS for MySQL has received more than 10 security certificates from both China and the international community.
It uses transparent data encryption (TDE) to encrypt source code data and protect data from being stolen. ApsaraDB for RDS running MySQL 5.7 or 8.0 supports SSL encryption, ECS security group, disk encryption, Bring Your Own Key (BYOK), and rotation of keys.

CloudDBA

CloudDBA is integrated into the ApsaraDB for RDS console. It monitors the performance metrics and slow SQL statements of your database instances and provides suggestions to locate performance issues.