Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-Time Migration and Synchronization from MySQL to MySQL/ Full or Incremental Phase Error: Access denied for user ***
Updated on 2023-01-17 GMT+08:00
View PDF
Share

Full or Incremental Phase Error: Access denied for user ***

Scenarios

During a full or incremental migration or synchronization, an error is reported. The log information is as follows: service %s failed, cause by: Unable to connect to DBMS: url=***?useUnicode=true&allowLoadLocalInfile=false&characterEncoding=UTF-8&connectTimeout=5000&useSSL=false&allowPublicKeyRetrieval=true&verifyServerCertificate=false&serverTimezone=UTC user=%s, Caused by: Access denied for user %s

Possible Causes

The connection to the source or destination database fails to be established.

Solution

  1. Check whether the source or destination database is running properly.
  2. Check whether the password for connecting to the source or destination database is correct.
  3. Check whether the network connection between the DRS instance and the source or destination database is normal.
  4. Check whether the IP address of the DRS instance is allowed to access the source or destination database.