After you create an AnalyticDB for MySQL cluster, you must configure a whitelist for the cluster to allow access from external devices to the cluster.

Background information

  • The default whitelist of an AnalyticDB for MySQL cluster contains only the default IP address 127.0.0.1, which indicates that no devices are allowed to access the cluster.
  • Whitelists can enhance access security for AnalyticDB for MySQL clusters. We recommend that you maintain the whitelists on a regular basis.
  • Whitelists do not affect the normal operation of AnalyticDB for MySQL clusters.

Procedure

  1. Log on to the AnalyticDB for MySQL console.
  2. In the upper-left corner of the page, select the region where clusters reside.
  3. In the left-side navigation pane, click Clusters.
  4. On the Data Warehouse Edition (V3.0) tab, click the target Cluster ID.
  5. In the left-side navigation pane, click Data Security.
  6. On the Whitelist Settings tab, click Edit to the right of the default whitelist.
    Note You can also click Create Whitelist to create a whitelist.
  7. In the Edit Whitelist panel, remove the default IP address 127.0.0.1 and enter the IP addresses or CIDR blocks that you want to allow. Then, click OK.
    • If you enter a CIDR block, access from all IP addresses in the CIDR block is allowed.
    • Do not add 0.0.0.0 to the whitelist.
    • If your public IP addresses change frequently and you want to allow all your public IP addresses, you can add 10.0.0.0/0 to the whitelist.
      Warning Risks may arise if you add 10.0.0.0/0 to the whitelist. Proceed with caution.
    • If you want to add multiple IP addresses or CIDR blocks, separate multiple entries with commas (,). Do not add spaces before or after the commas. Example: 192.168.0.1,172.16.213.9.
    • The whitelist modification takes effect in 1 minute.