Updated on 2023-02-02 GMT+08:00

Checking Whether the Source Database Is Connected

MySQL Migration

Table 1 Checking whether the source database is connected

Check Item

Whether the source database is connected

Description

Check the connectivity and accuracy of the IP address, port number, username, and password of the source database.

Failure Cause and Handling Suggestion

Failure cause: The connection fails.

Failure cause: Incorrect username or password

Handling suggestion: Check whether the input username and password for the connection test are correct.

Failure cause: The database account does not allow remote connections.

Handling suggestion:

Run the following command to create a user that allows remote connections. After the migration, delete this user.

CREATE USER 'Account' @ '%' IDENTIFIED BY 'Password'

Failure cause: The SSL CA root certificate is invalid.

Handling suggestion: Upload a valid SSL CA certificate.

Failure cause: No SSL CA root certificate exists.

Handling suggestion: Contact technical support.

Failure cause: The database is unavailable.

Handling suggestion: Contact technical support.