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

FlexusRDS does not provide super permissions for the root user. 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, FlexusRDS provides alternative methods.

Example 1: The command set global parameter_name=parameter_value; cannot be used to modify parameter values of a FlexusRDS instance. You can modify FlexusRDS instance parameter values only through the console.

Example 2: An error is reported after you run create definer='root'@'%' trigger(procedure)… because the root user does not have super permissions. To solve this problem, delete definer='root' from the command.