Changing a Database Port

Scenarios

Procedure

1. Log in to the management console.
2. Click in the upper left corner and select a region and a project.
3. Click Service List. Under Database, click 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 next to the Database Port field.

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

   Note

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

   • To submit the change, click .
     • In the dialog box, click OK.
       1. 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.
       2. If you change the database port of a read replica, the change will not affect other DB instances. Only the read replica will reboot.
          Note

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

       3. This process takes 1-5 minutes.
     • In the dialog box, click Cancel to cancel the modification.

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