Windows系统连接
<p>本文主要介绍如何在Windows操作系统的ECS上安装MySQL客户端,并通过MySQL客户端访问RDS-MySQL实例。</p>
<p><span style="font-size:18px"><strong>前提条件</strong></span></p>
<p>1. 您已成功绑定账号与数据库,可参考<a href="https://pinganyun.com/ssr/help/database/RDS/Getting_Started.RDS_MySQL.Binding_Account" target="_blank">授权账号与数据库权限</a>。</p>
<p>2. 您已成功创建ECS,且实例处于运行中,可参考<a href="https://pinganyun.com/ssr/help/database/RDS/Getting_Started.RDS_MySQL.Create_ECS" target="_blank">创建ECS</a>,创建ECS时,镜像请选择Windows。</p>
<p>3. 您已成功开通白名单,可参考<a href="https://pinganyun.com/ssr/help/database/RDS/Getting_Started.RDS_MySQL.Create_Whitelist" target="_blank">开通白名单</a>。</p>
<p><span style="font-size:18px"><strong>操作步骤</strong></span></p>
<p>1. 登录ECS,可参考<a href="https://pinganyun.com/ssr/help/compute/ecs/Quick_Start.Windows_Quick_Start.Login_Instance" target="_blank">登录Windows云主机</a>。</p>
<p>2. 下载并安装MySQL-Front客户端,<a href="http://www.mysqlfront.de/" target="_blank">下载地址</a>。</p>
<p>3. 启动MySQL-Front客户端。</p>
<p>4. 输入以下内容,连接RDS-MySQL实例。</p>
<p><img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20191507120014-10a97d039fe5.png" style="height:372px; width:290px" /></p>
<table border="1" cellpadding="0" cellspacing="0">
<tbody>
<tr>
<td style="background-color:#ededed">
<p><strong>配置项</strong></p>
</td>
<td style="background-color:#ededed">
<p><strong>说明</strong></p>
</td>
</tr>
<tr>
<td>
<p>名称</p>
</td>
<td>
<p>连接数据库的任务名称,如果不填写,默认采用<strong>主机</strong>名称。</p>
</td>
</tr>
<tr>
<td>
<p>主机</p>
</td>
<td>
<p>RDS-MySQL实例的访问域名。</p>
<p><img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20191507120051-186770629592.png" style="height:26px; margin:0px; width:65px" />:可在目标RDS-MySQL实例的<strong>基本信息</strong>页面查询,可参考<a href="https://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_MySQL.Instance_Management.View_Instance.View_Common_Instance" target="_blank">查看常规实例基本信息</a>。</p>
</td>
</tr>
<tr>
<td>
<p>端口</p>
</td>
<td>
<p>RDS-MySQL实例的端口号。</p>
<p><img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20191507120051-186770629592.png" style="height:26px; margin:0px; width:65px" />:可在目标RDS-MySQL实例的<strong>基本信息</strong>页面查询,可参考<a href="https://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_MySQL.Instance_Management.View_Instance.View_Common_Instance">查看常规实例基本信息</a>。</p>
</td>
</tr>
<tr>
<td>
<p>连接类型</p>
</td>
<td>
<p>MySQL-Front客户端支持:</p>
<ul>
<li>内建</li>
<li>动态库</li>
<li>HTTP隧道</li>
</ul>
</td>
</tr>
<tr>
<td>
<p>用户</p>
</td>
<td>
<p>RDS-MySQL数据库的目标用户名。</p>
<p><img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20191507120051-186770629592.png" style="height:26px; margin:0px; width:65px" />:可在目标RDS-MySQL实例的<strong>账号管理</strong>页面查询,可参考<a href="https://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_MySQL.Account.Create_Account" target="_blank">创建账号</a>。</p>
</td>
</tr>
<tr>
<td>
<p>密码</p>
</td>
<td>
<p>指定用户的密码。</p>
</td>
</tr>
<tr>
<td>
<p>数据库</p>
</td>
<td>
<p>需要连接的数据库名称,可为空。</p>
</td>
</tr>
</tbody>
</table>
<p>5. 单击<strong>确定</strong>。</p>
<p>6. 在<strong>连接管理</strong>页面,选择目标任务,单击<strong>打开</strong>。</p>
<p><img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20191507141002-1c909667984d.png" style="height:283px; width:318px" /></p>
<p><span style="font-size:18px"><strong>执行结果</strong></span></p>
<p>成功连接RDS-MySQL数据库。</p>
<p><img src="https://pcp-portal-sca.obs-cn-shenzhen.pinganyun.com/pcp-portal-sca/20191507141019-18cb88f193ea.png" style="height:285px; width:485px" /> </p>
<p> </p>
提交成功!非常感谢您的反馈,我们会继续努力做到更好!