Why Does the Root User Not Have the Super Permissions?
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, 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.
Database Permission FAQs
- Why Does the Root User Not Have the Super Permissions?
- What Are the Differences Between RDS ManageAccess and DAS Permissions?
- RDS for MySQL Built-in Accounts
- Does RDS for MySQL Support Multiple Accounts?
- Can Multiple Users Log In to DAS at the Same Time? Will the Accounts Be Locked If I Enter Wrong Passwords Several Times in a Row?
- Why Did I Fail to Create an Object on the postgres Database as a Common User?
- What Should I Do If a Role Failed to Be Deleted from an RDS for PostgreSQL Instance?
- Why Did My RDS for PostgreSQL Migration Fail?
- How Do I Grant the REPLICATION Permission to an RDS for PostgreSQL Database User?
- Why Is An Error Reported When I Attempt to Change a Table Owner of the RDS for PostgreSQL Database?
- How Are the Login Name Permissions of RDS for SQL Server 2017 Enterprise Edition Primary/Standby DB Instances Synchronized to Its Read Replicas?
- After a Primary Instance Account Is Deleted and Recreated on RDS for SQL Server, Will the Permissions Be Automatically Synchronized?
- How Do I View Authorized Databases After a Local Client Is Connected to a DB Instance?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore