Problem description
"Get schema connection timeout" error reported when creating a data migration task.
Cause
The possible errors are as follows:
Cause 1: a whitelist is set for your source database. As a result, the DTS server cannot be connected.
Cause 2: the host name of the migration account is localhost. Therefore, you cannot connect to the DTS server remotely.
Solution
Solution for cause 1: We recommend that you release the whitelist and try again. For more information, see Use a database client or the CLI to connect to an ApsaraDB RDS for MySQL instance.
Solution to cause 2: We recommend that you change the hostname of the account to "%" and try again.
grant all on *.* to [$User]@'%' identified by '[$Password]';NoteNote:
[$User] is the migration account.
[$Password] is the Password of the migration account.
Application scope
Data Transmission Service (DTS)