• Relational Database Service

rds
  1. Help Center
  2. Relational Database Service
  3. User Guide
  4. FAQs
  5. General FAQs
  6. Why Does the root Account Not Have the super Permission?

Why Does the root Account Not Have the super Permission?

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:

  1. Example 1: You are not allowed to log in to a database and run the following command to modify parameter values. You can only use the RDS console to modify parameter values.

    set global parameter name=Parameter value;

  2. Example 2: An error will be reported after you run the following command. This is because the root user does not have the super permission. You can delete define='root' from the command to solve the problem.

    create definer='root'@'%' trigger(procedure)...