Search code examples
mysqlamazon-web-servicesamazon-aurora

How to add 'Super' privileges to the Aurora database?

Although a variation of this question has been asked before it did not help. [Link][1] 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? [1]: how to add super privileges to mysql database?

Solution

  • 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.