On this page

Show all

Help Center/ Relational Database Service/ FAQs/ Database Permission/ Why Does the Root User Not Have the Super Permissions?

Why Does the Root User Not Have the Super Permissions?

Updated on 2023-09-20 GMT+08:00

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

    You can import data using mysqldump. For details, see Migrating Data to RDS for MySQL Using mysqldump.

  • Scenario 3: If you cannot create RDS for PostgreSQL plugins due to lack of super permissions, see Creating or Deleting a Plugin.
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback