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

FlexusRDS for MySQL does not provide super permissions for the root user. That's because the super permissions allow you to execute management commands, such as reset master, set global, and reset slave. These operations can 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 for MySQL instance. You can modify 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.