Use Navicat to connect to an RDS instance over SSH - ApsaraDB RDS

This topic describes how to use Navicat, a third-party database management tool, to connect to an ApsaraDB for RDS instance that runs MySQL, SQL Server, PostgreSQL, or MariaDB.

Prerequisites

Before you connect to the database, you must create an instance, a database, and an account for your database engine, and configure an IP address whitelist for the instance:

Create an RDS instance: Create an RDS for MySQL instance, Create an RDS for SQL Server instance, Create an RDS for PostgreSQL instance, Create an RDS for MariaDB instance
Create a database: Create a MySQL database, Create a SQL Server database, Create a PostgreSQL database, Create a MariaDB database
Create an account: Create a MySQL account, Create a SQL Server account, Create a PostgreSQL account, Create a MariaDB account
Configure an IP address whitelist: Configure a whitelist for a MySQL instance, Configure a whitelist for a SQL Server instance, Configure a whitelist for a PostgreSQL instance, Configure a whitelist for a MariaDB instance

Procedure

Start the Navicat client.
In the upper-left corner, click Connection and select your database type.

Note
If you use an earlier version of Navicat and the Alibaba Cloud menu is not available, you can directly select a database type, such as MySQL or PostgreSQL.

In the Navicat toolbar, click Connection, select Alibaba Cloud from the drop-down menu, and then select the target database type from the submenu, such as Alibaba Cloud ApsaraDB for RDS (MySQL)..., Alibaba Cloud ApsaraDB for RDS (PostgreSQL)..., or Alibaba Cloud ApsaraDB for RDS (SQL Server)....

Enter the connection information for the RDS instance. The following table describes the parameters.

Parameter	Description
Connection Name	A custom name for the connection.
Host	The internal endpoint or public endpoint of the RDS instance. Use the internal endpoint if your client is on an ECS instance in the same account, region, and VPC as the RDS instance. In other cases, use the public endpoint.
Port	The internal port or public port of the RDS instance. For example, the default port for MySQL is 3306.
User Name	The username for the account that accesses the RDS instance. You can find this on the instance's Accounts page.
Password	The password for the specified username.

Click OK.

Note
If enhanced whitelist mode is enabled and you want to connect to the instance over the internet, add the public IP address of your client to the classic network group.

After successfully connecting with a client such as Navicat, if you see databases such as busudab, information_schema, and mysql in the connection tree, the connection is successful.

Related operations

You can also connect to the database using other methods, such as Data Management Service (DMS) or the CLI. For more information, see Connect to an RDS for MySQL instance, Connect to an RDS for SQL Server instance, Connect to an RDS for PostgreSQL instance, and Connect to an RDS for MariaDB instance.

FAQ

If you cannot connect to the RDS instance, see What do I do if I fail to connect to an ApsaraDB RDS instance?.