Help Center> Relational Database Service> User Guide> Working with RDS for MySQL> Connection Management> Changing the Database Port
View PDF

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.

Constraints

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

  • Bind an EIP to the DB instance.
  • Delete the DB instance.
  • Create a backup for 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. The RDS console is displayed.
  4. On the Instance Management page, click the target DB instance or click first and then click the target read replica.
  5. In the Connection Information area on the Basic Information page, click in the Database Port field.

    You can also choose Connection Management in the navigation pane on the left. In the Connection Information pane on the Public Connection or Private Connection page, click in the Database Port field.

    The MySQL database port ranges from 1024 to 65535, excluding 12017 and 33071, which are occupied by the RDS system and cannot be used.

    • To submit the change, click .
      • In the dialog box, click Yes.

        If you have enabled the operation protection function, click Send Code in the displayed Identify Verification dialog box and enter the obtained verification code. Then, click OK.

        Two-factor authentication is required to improve the security of your account and cloud product. For details about how to enable operation protection, see the Identity and Access Management User Guide.

        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 be rebooted.
        3. This process takes 1-5 minutes.
      • In the dialog box, click No to cancel the modification.
    • To cancel the change, click .

  6. View the result of the change on the Basic Information page.
Parent topic: Connection Management