Take a look at this post: https://repost.aws/knowledge-center/duplicate-master-user-mysql
Error Code 1227 - Access Denied: This error suggests that your current user account does not have sufficient privileges to perform the operation you are attempting.
Verify Your Privileges: First, ensure that your user account truly has super admin privileges. You can check this by executing the following SQL command:
SHOW GRANTS FOR 'yourusername'@'yourhost';
- Why am I getting an Access Denied error when I try to connect to Amazon RDS for MySQL using IAM authentication?AWS OFFICIALUpdated 7 months ago
- How can I resolve 1227 and definer errors when importing data to my Amazon RDS for MySQL DB instance using mysqldump?AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 4 years ago
- EXPERTpublished 6 months ago