Why Does the Root User of My RDS Instance Not Have the Super Permissions?

RDS does not provide super permissions for the root user. The super permissions allow you to execute management commands, such as reset master, set global, kill thread_ID, and reset slave. These operations may cause primary/standby replication errors.

If you need to perform operations that require super permissions, RDS provides alternative methods.

• Scenario 1: If you cannot run the following command on an RDS instance to modify parameter values, you can modify parameter values through the RDS console.

  set global parameter name=Parameter value;

  If the script contains the set global command, delete the set global command and modify parameter values on the RDS console.

• Scenario 2: An error is reported after you run the following command because the root user does not have the super permissions. To solve this problem, delete definer='root' from the command.

  create definer='root'@'%' trigger(procedure)...

  You can import data using mysqldump. For details, see Migrating Data to RDS for MySQL Using mysqldump.

• Scenario 3: If you cannot create RDS for PostgreSQL extensions due to lack of super permissions, see Creating or Deleting an Extension.