Help Center/ Data Replication Service/ User Guide (ME-Abu Dhabi Region)/ Troubleshooting/ Solutions to Failed Check Items/ Networks/ Checking Whether the Destination Database Is Connected
Updated on 2023-02-02 GMT+08:00
View PDF
Share

Checking Whether the Destination Database Is Connected

MySQL Migration

Table 1 Checking whether the destination database is connected

Check Item

Whether the destination database is connected

Description

Check the connectivity and accuracy of the IP address, port number, username, and password of the destination 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 database is unavailable.

Handling suggestion: Contact technical support.
Parent topic: Networks