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 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.
- In the task list, locate the target task and click Resume in the Operation column to resume the task.