使用 AWS re:Post 即表示您同意 AWS re:Post 使用條款
AWS re:Postre:Post

MySQL RDS - Associating a user to a group fails with "Error Code: 1227. Access denied"

0

I am connected to MySQL RDS instance of our database with super admin privileges. When I execute the following statements below it results in error

Error Code: 1227. Access denied; you need (at least one of) the WITH ADMIN, ROLE_ADMIN, SUPER privilege(s) for this operation 0.047 sec

CREATE ROLE read_only_user; GRANT SELECT on * TO read_only_user; grant 'read_only_user' TO 'myuser@company.com';

We are in the process of migrating to Aurora and the same stamens works fine in an Auora instance of the database.

主題
資料庫
標籤
資料庫Aurora MySQLMySQL
語言
English
vlaiosa
已提問 5 個月前檢視次數 408 次
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';

Jesus Castellanos
已回答 5 個月前
  • vlaiosa
    5 個月前

    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

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋，同時有助於提問者的專業成長。

回答問題指南

相關內容