All Products
Search
Document Center

:A connection timeout occurs when you create a data migration task

Last Updated:Aug 02, 2024

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]';
    Note

    Note:

    • [$User] is the migration account.

    • [$Password] is the Password of the migration account.

Application scope

  • Data Transmission Service (DTS)