<p>This article describes how to modify permissions for an account to access database.</p> <p><span style="font-size:18px"><strong>Overview</strong></span></p> <p>After creating an account and database, you need to assign the read-only or read/write permission of accessing a designated database to an account.</p> <p><span style="font-size:18px"><strong>Prerequisites</strong></span></p> <ol> <li>You have successfully created an account. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_MySQL.Account.Create_Account" target="_blank">Create an Account</a>.</li> <li>You have successfully created a database. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_MySQL.Database.Create_Database" target="_blank">Create a Database</a>.</li> </ol> <p><span style="font-size:18px"><strong>Procedures</strong></span></p> <p>1.&nbsp; Log in to the <a href="http://pinganyun.com/console/rds/overview" target="_blank">RDS Console</a>.</p> <p>2.&nbsp; In the left navigation pane, click <strong>RDS-MySQL</strong> to enter the <strong>DBPaaS for RDS-MySQL</strong> page.</p> <p>3.&nbsp; Select the target region.</p> <p>4.&nbsp; Click <strong>Manage</strong> in the <strong>Operations</strong> column of the target instance and select <strong>Account</strong> tab.</p> <p>5.&nbsp; In the <strong>Operations </strong>column of the target account, click <strong>Modify Permissions</strong>.</p> <p>6.&nbsp; Select the target database in the list of <strong>Unauthorized Database</strong> and click <img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200307165044-139464419d18.png" style="height:30px; margin:0px; width:35px" />.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200307165027-19803f6694f2.png" style="height:335px; width:830px" /></p> <p>7.&nbsp; Select the target database in the list of <strong>Authorized Database,</strong> and click <strong>Read and write</strong> or <strong>Read-only</strong> to assign the permission of accessing database to the account.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200307165035-13ae5ca4925b.png" style="height:330px; width:830px" /></p> <p>8.&nbsp; Click <strong>Save</strong>.</p> <p><span style="font-size:18px"><strong>Result</strong></span></p> <p>1.&nbsp; On the <strong>Account</strong> page, <strong>Database Belonging</strong> of the target account is the target database. Permission of the target database is <strong>Processing</strong>.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200307165051-1071b7b19c82.png" style="height:142px; width:830px" /></p> <p>2.&nbsp; After successfully modifying the permission, you can see that <strong>Database Belonging</strong> of the target account is the target database. Permission of the target database is target permission.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200307165057-1a1dd7919f24.png" style="height:143px; width:830px" /></p>