<p class="shortdesc">本文主要介绍如何修改账号对数据库的访问权限。</p> <section class="section prereq" id="Modify_Permissions_PG__prereq_zgr_j52_hsb"><div class="tasklabel"><h2 class="doc-tairway">前提条件</h2></div> <ol class="ol" id="Modify_Permissions_PG__ol_d5x_nt2_hsb"> <li class="li">您已成功创建数据库，可参考<a class="xref" href="/ssr/help/database/MySQL/Guide.Database.Create_Database" target="_blank" rel="external noopener">创建数据库</a>。</li> <li class="li">您已成功创建用户，可参考<a class="xref" href="/ssr/help/database/MySQL/Guide.Account.Create_Account" target="_blank" rel="external noopener">创建用户</a>。</li> </ol> </section> <section class="section context"><div class="tasklabel"><h2 class="doc-tairway">背景信息</h2></div> <p class="p">成功创建账号与数据库后，需要授权账号对指定数据库的只读或读写访问权限。</p> </section> <section><div class="tasklabel"><h2 class="doc-tairway">操作步骤</h2></div><ol class="ol steps"><li class="li step"> <span class="ph cmd">以资源组管理员身份登录<a class="xref" href="https://www.ocftcloud.com/console/rds/mysql" target="_blank" rel="external noopener">RDS-MySQL管理控制台</a>。</span> </li><li class="li step"> <span class="ph cmd">单击左侧导航栏<span class="ph uicontrol">RDS-MySQL</span>，进入<span class="ph uicontrol">云数据库管理</span>页面。</span> </li><li class="li step"> <span class="ph cmd">选择目标地域。</span> </li><li class="li step"> <span class="ph cmd">单击目标实例<span class="ph uicontrol">操作</span>列的<span class="ph uicontrol">管理</span>，选择<span class="ph uicontrol">账号管理</span>页签。</span> </li><li class="li step"> <span class="ph cmd">单击目标账号<span class="ph uicontrol">操作</span>列的<span class="ph uicontrol">修改权限</span>。</span> </li><li class="li step"> <span class="ph cmd">从<span class="ph uicontrol">未授权数据库</span>列表中选择目标数据库，单击<img class="image" id="Modify_Permissions_PG__image_lg1_n52_hsb" src="https://obs-cn-shanghai.fincloud.pinganyun.com/pacloud/20222410144209-18a5a9319eed.png">。</span> </li><li class="li step"> <span class="ph cmd">在<span class="ph uicontrol">已授权数据库</span>列表中选择目标数据库，单击<span class="ph uicontrol">读写</span>或<span class="ph uicontrol">只读</span>，授予该账号对数据库的访问权限。</span> </li><li class="li step"> <span class="ph cmd">单击<span class="ph uicontrol">确认</span>。</span> </li></ol></section> <section class="section result"><div class="tasklabel"><h2 class="doc-tairway">执行结果</h2></div> <ol class="ol"> <li class="li">在<span class="ph uicontrol">账号管理</span>页面，目标账号对应的<span class="ph uicontrol">所属数据库</span>显示为目标数据库，权限显示为<span class="ph uicontrol">权限配置中</span>。</li> <li class="li">修改权限成功后，目标账号对应的<span class="ph uicontrol">所属数据库</span>显示为目标数据库，且权限为目标权限。</li> </ol> </section>