Most public cloud relational database vendors do not provide the super permission for the root account. Once a user has the super permission, the user can execute many management commands, such as reset master, set global, kill, and reset slave. This may cause abnormal primary/standby relationships. This is a major difference between public cloud databases and on-premises MySQL databases. To ensure stable running of DB instances, RDS does not provide the super permission for the root account.
If you require the super permission, RDS can provide service capabilities or use other methods to bypass the super permission restriction.
Examples are as follows:
set global parameter name=Parameter value;
create definer='root'@'%' trigger(procedure)...