<p>This article describes how to modify permissions of accessing a database by a designated account.</p> <p><span style="font-size:18px"><strong>Overview</strong></span></p> <p>After you successfully created database and account, you need to assign read-only or read/write permission to a designated account for accessing the database.</p> <p><span style="font-size:18px"><strong>Prerequisites</strong></span></p> <ol> <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> <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> </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>Database</strong> tab.</p> <p>5.&nbsp; In the <strong>Operations </strong>column of the target database, click <strong>Modify Permissions</strong>.</p> <p>6.&nbsp; Select the target account in the list of <strong>Unauthorized Account</strong> and click <img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200307160047-1e03d3eb9fbc.png" style="height:30px; margin:0px; width:35px" />.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200307160105-1938868f99f5.png" style="height:333px; width:830px" /></p> <p>7.&nbsp;&nbsp;&nbsp;&nbsp; Select the target account in the list of <strong>Authorized Account</strong> and click <strong>Read and write</strong> or <strong>Read-only</strong> to assign the permission of accessing the database to a designated account.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200307160112-1c1c6d5694fc.png" style="height:331px; 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>Database</strong> page, <strong>Binding Account</strong> of the target database is the target account. Permission of the target account is <strong>Processing</strong>.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200307160119-1482d63c965c.png" style="height:141px; width:830px" /></p> <p>2.&nbsp; After successfully modifying the permission, you can see that <strong>Binding Account</strong> of the target database is the target account. Permission of the target account is the target permission.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200307160125-1e18486c98cc.png" style="height:143px; width:830px" /></p>