1 Respuesta
- Más nuevo
- Más votos
- Más comentarios
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';
respondido hace 5 meses
Contenido relevante
- OFICIAL DE AWSActualizada hace 4 años
- OFICIAL DE AWSActualizada hace 2 años
- OFICIAL DE AWSActualizada hace 3 años
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