• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. Managing DB Instances
  5. Network
  6. Changing the Database Port

Changing the Database Port

Scenarios

This section describes how to change the database port of a primary DB instance or a read replica. For primary/standby DB instances, changing the database port of the primary DB instance will cause the database port of the standby DB instance to also be changed accordingly.

Restrictions

You cannot perform the following operations when the database port of a DB instance is being changed:

  • Binding an EIP
  • Delete the DB instance.
  • Create a backup for the DB instance.
  • Restore the DB instance from a backup to the original DB instance point in time.
  • Edit, change, reset, and delete a parameter group applied to the DB instance.

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 to go to the RDS console.
  4. On the Instance Management page, click the target DB instance or click and then the target read replica.
  5. On the displayed Basic Information page, click in the Database Port.

    NOTE:
    • The MySQL database port ranges from 1024 to 65535, excluding 12017 and 33071, which are occupied by the RDS system and cannot be used.
    • The PostgreSQL database port ranges from 2100 to 9500.
    • Microsoft SQL Server database ports can be 1433 or range from 2100 to 9500, excluding 5355 and 5985.
    • To submit the change, click .
      • In the dialog box, click Yes.
        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 reboot.
        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:

          Currently, RDS for Microsoft SQL Server does not support read replicas.

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

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