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>
提交成功!非常感谢您的反馈,我们会继续努力做到更好!