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 2024-11-30 GMT+08:00
View PDF
Share

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 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.