This topic describes how to use Navicat to connect to an RDS instance that runs MySQL, SQL Server, PostgreSQL, or MariaDB. Navicat is a third-party database management tool.
Alibaba Cloud has officially launched Data Management (DMS), which provides the graphical data management feature. This feature is used to manage relational databases and NoSQL databases, and supports capabilities such as data management, schema management, user authorization, security audit, data trend analysis, data tracking, BI charts, and performance and optimization.
We recommend that you use DMS to manage your databases. For more information about how to use DMS to connect to an RDS instance, see Use DMS to log on to an ApsaraDB RDS for MySQL instance.
Prerequisites
The following requirements are met:
An RDS instance is created. For more information, see Create an ApsaraDB RDS for MySQL instance.
The RDS instance is connected by using a database client or the CLI. For more information, see Use a database client or the CLI to connect to an ApsaraDB RDS for MySQL instance.
An account is created for the RDS instance. For more information, see Create databases and accounts for an ApsaraDB RDS for MySQL instance.
Procedure
Start the Navicat client.
In the upper-left corner, click Connection and select the type of the database to be connected.
NoteIf your Navicat client has not been upgraded to the latest version, the Alibaba Cloud menu is not displayed. You can select a database type such as MySQL or PostgreSQL.
Enter the information about the RDS instance to which you want to connect. The following table describes the required parameters.
Parameter
Description
Connection Name
Enter a custom name of the connection.
Host
Enter the internal or public endpoint of the RDS instance. The following list describes the internal and public endpoints:
If your client is deployed on an Elastic Compute Service (ECS) instance that resides in the same region and has the same network type as the RDS instance, use the internal endpoint. For example, if the ECS and RDS instances are both in a VPC located in the China (Hangzhou) region, you can use the internal endpoint of the RDS instance to create a secure connection.
In other situations, use the public endpoint.
For more information about how to view the internal and public endpoints and port numbers of an RDS instance, see View and manage instance endpoints and ports.
Port
If you want to connect to the RDS instance over the internal network, enter the internal port of the RDS instance. If you want to connect to the RDS instance over the public network, enter the public port of the instance.
Username
Enter the username of the account that is used to connect to the RDS instance.
Password
The password of the account that is used to connect to the RDS instance.
Click OK.
NoteIf you fail to connect to the RDS instance, troubleshoot the issue. For more information, see What do I do if I fail to connect to an ApsaraDB RDS instance?
If the enhanced whitelist mode is enabled for your RDS instance and you want to connect your device to the instance over the Internet, you must add the public IP address of the device to the IP address whitelist of the classic network type.
FAQ
For more information about how to troubleshoot the issue that you cannot connect to an RDS instance, see What do I do if I fail to connect to an ApsaraDB RDS instance?