Updated on 2022-09-21 GMT+08:00

Full Phase Error: Access denied for user '***' to database '***'

Scenarios

During a full migration or synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: retry structures failed events=the fail structures are [type=account, index=0, schema_name=mysql, object_name='***']reason:[Access denied for user '***' to database '***']

Possible Causes

The possible causes are as follows:

  • The DRS migration account does not have sufficient permissions on the destination database.

Solution

Contact the O&M engineers to add the schema permission to the migration account in the destination database. Then, in the task list, locate the row that contains the target task and click Resume in the Operation column to resume the task.