授权账号与数据库权限

<p class="shortdesc">本文主要介绍如何通过控制台授权账号对指定数据库的只读或读写权限。</p> <section class="section prereq" id="BindAccount__prereq_wr1_ljy_gsb"><div class="tasklabel"><h2 class="doc-tairway">前提条件</h2></div> <ol class="ol" id="BindAccount__ol_swh_ljy_gsb"> <li class="li">您已成功创建常规实例,可参考<a class="xref" href="/ssr/help/database/MySQL/Guide.IM.CIns.CCom" target="_blank" rel="external noopener">创建RDS-MySQL实例</a>。</li> <li class="li">您已成功创建账号,可参考<a class="xref" href="/ssr/help/database/MySQL/Guide.Account.Create_Account" target="_blank" rel="external noopener">创建用户</a>。</li> <li class="li">您已成功创建数据库,可参考<a class="xref" href="/ssr/help/database/MySQL/Guide.Database.Create_Database" 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">非托管模式下,在控制台创建好账号与数据库后,需要授权账号与数据库的权限。您可以授权账号对指定数据库的访问权限,也可以授权数据库被指定账号以何种访问权限访问。可参考账号管理的<a class="xref" href="/ssr/help/database/MySQL/Guide.Account.Modify_Permissions_PG" target="_blank" rel="external noopener">修改权限</a>,或数据库管理的<a class="xref" href="/ssr/help/database/MySQL/Guide.Database.Modify_Permissions" target="_blank" rel="external noopener">修改权限</a>。本文以授权数据库允许指定账号库的访问权限为例。 </p> <div class="note important note_important" id="BindAccount__note_yjv_hl2_dtb"><span class="note__title">重要:</span> <p class="p">托管模式下,不支持在RDS-MySQL管理控制台修改权限。</p> </div> </section> <section><div class="tasklabel"><h2 class="doc-tairway">操作步骤</h2></div><ol class="ol steps"><li class="li step stepexpand"> <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 stepexpand"> <span class="ph cmd">单击左侧导航栏<span class="ph uicontrol">RDS-MySQL</span>,进入<span class="ph uicontrol">云数据库管理</span>页面。</span> </li><li class="li step stepexpand"> <span class="ph cmd">选择目标地域。</span> </li><li class="li step stepexpand"> <span class="ph cmd">单击目标实例<strong class="ph b">操作</strong>列的<strong class="ph b">管理</strong>,选择<strong class="ph b">数据库管理</strong>页签。</span> </li><li class="li step stepexpand"> <span class="ph cmd">单击目标数据库<strong class="ph b">操作</strong>列的<strong class="ph b">修改权限</strong>。</span> </li><li class="li step stepexpand"> <span class="ph cmd">从<span class="ph uicontrol">未授权账号</span>列表中选择目标账号,单击<img class="image" id="BindAccount__image_xs1_pjy_gsb" src="https://obs-cn-shanghai.fincloud.pinganyun.com/pacloud/20222410144209-1aa2ebcf95a8.png">。</span> </li><li class="li step stepexpand"> <span class="ph cmd">在<span class="ph uicontrol">已授权账号</span>列表中选择目标账号,单击<span class="ph uicontrol">读写</span>或<span class="ph uicontrol">只读</span>,授予数据库允许指定账号的访问权限。</span> <div class="itemgroup info"> <p class="p"><img class="image" id="BindAccount__image_jhz_pjy_gsb" src="https://obs-cn-shanghai.fincloud.pinganyun.com/pacloud/20222410144209-1596259e94bf.png"></p> </div> </li><li class="li step stepexpand"> <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> <p class="p">在<span class="ph uicontrol">数据库管理</span>区域,目标数据库的<span class="ph uicontrol">绑定账号</span>显示为目标账号,且权限为目标权限。</p> </section>
以上内容是否解决了您的问题?
请补全提交信息!
联系我们

电话咨询

400-151-8800

邮件咨询

fincloud@ocft.com

在线客服

工单支持

解决云产品相关技术问题