Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-Time Migration and Synchronization from MySQL to MySQL> Full Phase Error: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
Updated on 2022-09-21 GMT+08:00

Full Phase Error: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

Scenarios

During a full migration, 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=function, index=2, schema_name= %s, object_name= %s]reason:[Access denied; you need (at least one of) the SUPER privilege(s) for this operation]

Possible Causes

The possible causes are as follows:

  • The user retained the definer for migration, but the migration account does not have the super permission.

Solution

Grant the super permission to the destination database user and submit the task again. For details, see RDS FAQs. Alternatively, you can choose not to migrate definers when recreating a task.