1

Although a variation of this question has been asked before it did not help. Link for anyone interested.

mysql> GRANT SUPER ON *.* TO root@'%' IDENTIFIED BY 'password';

I ran the above command but I receive the following error, even though I am the root user:

Access denied for user 'root'@'%' (using password: YES)

I have also create a custom Parameter Group and set the log_bin_trust_function_creators=1 and rebooted the instance, but still I don't have Super Privileges. Any ideas?

Community
  • 1
  • 1
Evan
  • 288
  • 1
  • 10
  • 19

1 Answers1

2

You cannot grant SUPER on an Aurora (or any RDS) database.

Some things that require SUPER can be set via the parameter group settings, and there are some built-in stored procedures for some other common task.

chris
  • 36,094
  • 53
  • 157
  • 237
  • thanks, that would make would make sense as one of the reasons I wanted need SUPER was to turn on "event_scheduler". But I found that you can just turn that on in parameters. – Evan Feb 23 '18 at 14:03