Help Center>
Relational Database Service>
FAQs>
Database Permission>
How Do I View Authorized Databases After a Local Client Is Connected to a DB Instance?
Updated on 2022-05-07 GMT+08:00
How Do I View Authorized Databases After a Local Client Is Connected to a DB Instance?
After connecting to the database on a local client, run the following command to grant permissions to view the database. In the command, ip indicates the local IP address.
show grants for root@'ip';
show grants for root@'%';
Parent topic: Database Permission
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
- RDS for MariaDB 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 My RDS for PostgreSQL Instance?
- 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?
- How Do I Create Accounts and Databases After Purchasing 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.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbotmore