Windows系统连接

<p class="shortdesc">本文主要介绍如何在Windows操作系统的ECS上安装MySQL客户端,并通过MySQL客户端访问RDS-MySQL实例。</p> <section class="section prereq" id="Windows__prereq_mbc_kxm_hsb"><div class="tasklabel"><h2 class="doc-tairway">前提条件</h2></div> <ol class="ol" id="Windows__ol_onr_kxm_hsb"> <li class="li">您已成功绑定账号与数据库,可参考<a class="xref" href="/ssr/help/database/MySQL/quick.BindAccount" target="_blank" rel="external noopener">授权账号与数据库权限</a>。</li> <li class="li">您已成功创建ECS,可参考<a class="xref" href="/ssr/help/database/MySQL/quick.CECS" target="_blank" rel="external noopener">创建ECS</a>,创建ECS时,镜像请选择Windows。</li> <li class="li">您已成功开通白名单,可参考<a class="xref" href="/ssr/help/database/MySQL/quick.CWhitelist" target="_blank" rel="external noopener">开通白名单</a>。</li> </ol> </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="/ssr/help/compute/ecs/manual.Instance.Login_Windows_Instance.Console_Remote_Login" target="_blank" rel="external noopener">登录Windows云主机</a>。</span> </li><li class="li step stepexpand"> <span class="ph cmd">下载并安装MySQL-Front客户端,<a class="xref" href="http://www.mysqlfront.de" target="_blank" rel="external noopener">下载地址</a>。</span> </li><li class="li step stepexpand"> <span class="ph cmd">启动MySQL-Front客户端。</span> </li><li class="li step stepexpand"> <span class="ph cmd">输入以下内容,连接RDS-MySQL实例。</span> <div class="itemgroup info"> <p class="p"><img class="image" id="Windows__image_grd_dwm_hsb" src="https://obs-cn-shanghai.fincloud.pinganyun.com/pacloud/20222410144209-164e86dc94b1.png"></p> <table class="table" id="Windows__table_ssm_dly_gsb"><caption></caption><colgroup><col><col></colgroup><thead class="thead"> <tr class="row"> <th class="entry colsep-1 rowsep-1" id="Windows__table_ssm_dly_gsb__entry__1"> <p class="p">配置项</p> </th> <th class="entry colsep-1 rowsep-1" id="Windows__table_ssm_dly_gsb__entry__2"> <p class="p">说明</p> </th> </tr> </thead><tbody class="tbody"> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__1 "> <p class="p"> 名称 </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__2 "> <p class="p"> 连接数据库的任务名称,如果不填写,默认采用<span class="ph uicontrol">主机</span>名称。 </p> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__1 "> <p class="p"> 主机 </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__2 "> <p class="p">RDS-MySQL实例的访问域名。</p> <div class="note important note_important" id="Windows__note_nms_f51_3sb"><span class="note__title">重要:</span> <p class="p">可在目标RDS-MySQL实例的<span class="ph uicontrol">基本信息</span>页面查询,可参考<a class="xref" href="/ssr/help/database/MySQL/Guide.IM.ViewIns.View_Common_Instance" target="_blank" rel="external noopener">查看实例基本信息</a>。</p> </div> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__1 "> <p class="p"> 端口 </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__2 "> <p class="p">RDS-MySQL实例的端口号。</p> <div class="note important note_important" id="Windows__note_xxj_zxs_m5b"><span class="note__title">重要:</span> <p class="p">可在目标RDS-MySQL实例的<span class="ph uicontrol">基本信息</span>页面查询,可参考<a class="xref" href="/ssr/help/database/MySQL/Guide.IM.ViewIns.View_Common_Instance" target="_blank" rel="external noopener">查看实例基本信息</a>。</p> </div> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__1 "> <p class="p"> 连接类型 </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__2 "> <p class="p">MySQL-Front客户端支持:</p> <ul class="ul" id="Windows__ul_vsm_dly_gsb"> <li class="li">内建</li> <li class="li">动态库</li> <li class="li">HTTP隧道</li> </ul> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__1 "> <p class="p"> 用户 </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__2 "> <p class="p">RDS-MySQL数据库的目标用户名。</p> <div class="note important note_important" id="Windows__note_wxm_h51_3sb"><span class="note__title">重要:</span> <p class="p">可在目标RDS-MySQL实例的<span class="ph uicontrol">账号管理</span>页面查询,可参考<a class="xref" href="/ssr/help/database/MySQL/Guide.Account.Create_Account" target="_blank" rel="external noopener">创建账号</a>。</p> </div> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__1 "> <p class="p"> 密码 </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__2 "> <p class="p"> 指定用户的密码。 </p> </td> </tr> <tr class="row"> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__1 "> <p class="p"> 数据库 </p> </td> <td class="entry colsep-1 rowsep-1" headers="Windows__table_ssm_dly_gsb__entry__2 "> <p class="p"> 需要连接的数据库名称,可为空。 </p> </td> </tr> </tbody></table> </div> </li><li class="li step stepexpand"> <span class="ph cmd">单击<span class="ph uicontrol">确定</span>。</span> </li><li class="li step stepexpand"> <span class="ph cmd">在<span class="ph uicontrol">连接管理</span>页面,选择目标任务,单击<span class="ph uicontrol">打开</span>。</span> <div class="itemgroup info"> <p class="p"><img class="image" id="Windows__image_o2h_gwm_hsb" src="https://obs-cn-shanghai.fincloud.pinganyun.com/pacloud/20222410144210-157ed1809761.png"></p> </div> </li></ol></section> <section class="section result"><div class="tasklabel"><h2 class="doc-tairway">执行结果</h2></div> <p class="p">成功连接RDS-MySQL数据库。</p> <p class="p"><img class="image" id="Windows__image_jxd_jwm_hsb" src="https://obs-cn-shanghai.fincloud.pinganyun.com/pacloud/20222410144210-1425b9ae9ace.png"></p> </section>
以上内容是否解决了您的问题?
请补全提交信息!
联系我们

电话咨询

400-151-8800

邮件咨询

fincloud@ocft.com

在线客服

工单支持

解决云产品相关技术问题