Help Center> Relational Database Service> FAQs> Database Permission> Why Does the Root User Not Have the Super Permissions?
Updated on 2023-04-20 GMT+08:00

Why Does the Root User 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, 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 plugins due to lack of super permissions, see Creating or Deleting a Plugin.

Database Permission FAQs

more