RDS MySQL Database Migration and Privilege Error

0

Hi,

I am currently migrating an existing RDS MySQL database to a new MySQL database in order to change the master username. I have taken a dump of the old database and configured the new database with the same settings. However, while importing the dump file, I encountered the following error: ** "ERROR 1227 (42000) at line 20387: Access denied; you need (at least one of) the SUPER or SET_USER_ID privilege(s) for this operation."**

I have attempted to resolve this by ensuring that the new database user has the necessary privileges, but the issue persists. Any guidance or suggestions on how to overcome this privilege error during the import process would be greatly appreciated.

Thank you!

1 Answer
0

Hello.

Why not try dumping by adding "--set-gtid-purged=OFF" to the dump command option?
https://stackoverflow.com/questions/54432983/aws-rds-mysql-error-scenario-when-restoring-data-generates-error-error-1227420

profile picture
EXPERT
answered 2 months ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions