Changing a Database Port

Scenarios

This section describes how to change the database port of an RDS primary instance or read replica. If you change the database port of a primary instance, the standby instance's port will also be changed.

If specific security group rules have been configured for a DB instance, you need to change the inbound rules of the security group to which the DB instance belongs after changing the database port.

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click in the upper left corner of the page and choose Database > Relational Database Service.
4. On the Instances page, click the target DB instance name or click first and then click the target read replica name.
5. In the Connection Information area on the Basic Information page, click Change next to the Database Port field.

   Alternatively, choose Connectivity & Security in the navigation pane on the left. In the Connection Information area, click Change next to the Database Port field.

   

   The DB instance port is 1433 by default or it can be set to a value from 2100 to 9500, excluding 5355 and 5985.

   • In the displayed dialog box, click Yes.
     • If you change the database port of the primary DB instance, that of the standby DB instance will also be changed and both DB instances will be rebooted.
     • If you change the database port of a read replica, the change will not affect other DB instances. Only the read replica will reboot.
       

       For RDS for SQL Server, only 2017 Enterprise Edition supports read replicas.

     • This process takes 1 to 5 minutes.
   • In the displayed dialog box, click No to cancel the modification.

6. View the result of the change on the Basic Information page.