Help Center/ Relational Database Service_RDS for MariaDB/ FAQs/ Database Permissions/ Why Does the Root User of My RDS for MariaDB Instance Not Have the Super Permissions?
Updated on 2025-06-24 GMT+08:00

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

RDS does not provide the 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)...