DB access setting Problem

Available in VPC

You might run into the following problems when using Database Migration Service. Find out causes and possible solutions.

Source DB and Target DB server communication error

Source DB and Target DB servers are not communicating.

Cause

You need to set the connection information to connect the Source DB server and the Target DB server before migration.

Solution

Inspect the Inbound ACG policy of the Source DB and the Outbound ACG policy of the Target DB. For more information on connection settings by migration quickstart, see Source DB and Target DB connection settings.

Source DB access error

Attempted Test Connection but cannot access Source DB.

Cause

• The firewall (ACG) of the source DB server does not allow access from the target DB.
• The target DB IP range is not included in the allowed host list (DB ACL) for the source DB account. (Error code 1130)
• The password of the account used for migration is incorrect. (Error code 1045)

Solution

Edit ACG's Inbound rules applied to the Source DB server to allow the following traffic:

• Protocol: TCP
• Access source: Public domain IP address allocated to Target DB (Example: 101.101.220.246/32)
• Allowed port: Target DB access port
• In the source DB, add the IP address range of the subnet where the target DB is created to the allowed hosts for the migration account.
• Verify that the password of the account used for migration is correct.

Display DB ACL check message

When trying Test Connection, DB ACL check message displays.

Cause

For Source DB backup and replication, you need Target DB access, backup, and replication permissions for the account created in mysql_native_password format.

Solution

Assign Target DB access, backup, and replication permissions for the account created in mysql_native_password format. For more information, see creating Source DB account and setting ACL.

BACKUP_ADMIN/RELOAD permission

I want to use mydumper method, but I recieved the message BACKUP_ADMIN/RELOAD permissions.

Cause

BACKUP_ADMIN permissions are granted only to DDL accounts on cluster with version 8.0.23 or later.

Solution

If you need this permission for other versions, request with Source DB information through customer inquiry. This is only possible if the Source DB is the Cloud DB for MySQL cluster.