1回答
- 新しい順
- 投票が多い順
- コメントが多い順
0
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';
回答済み 5ヶ月前
関連するコンテンツ
- AWS公式更新しました 3年前
My user does have super admin privileges (see below). Also, I have an instance of a MySQL Aurora database with the same super admin privileges and it works fine.
GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER, CREATE ROLE, DROP ROLE ON . TO admin@% WITH GRANT OPTION GRANT APPLICATION_PASSWORD_ADMIN,BACKUP_ADMIN,FLUSH_OPTIMIZER_COSTS,FLUSH_STATUS,FLUSH_TABLES,FLUSH_USER_RESOURCES,INNODB_REDO_LOG_ARCHIVE,PASSWORDLESS_USER_ADMIN,SHOW_ROUTINE ON . TO admin@% WITH GRANT OPTION