<p>本文主要介绍如何在Windows操作系统的ECS上安装MySQL客户端，并通过MySQL客户端访问DRDS实例。</p> <p><span style="font-size:18px"><strong>前提条件</strong></span></p> <p>1.&nbsp; 您已成功绑定账号与数据库，可参考<a href="https://www.ocftcloud.com/ssr/help/database/DRDS/quick_start.Binding_Account" target="_blank">授权账号与逻辑库权限</a>。</p> <p>2.&nbsp; 您已成功创建ECS，且实例处于运行中，可参考<a href="https://www.ocftcloud.com/ssr/help/database/DRDS/quick_start.Create_ECS" target="_blank">创建ECS</a>，创建ECS时，镜像请选择Windows。</p> <p>3.&nbsp; 您已成功开通白名单，可参考<a href="https://www.ocftcloud.com/ssr/help/database/DRDS/quick_start.Create_Whitelist" target="_blank">开通白名单</a>。</p> <p><span style="font-size:18px"><strong>操作步骤</strong></span></p> <p>1.&nbsp; 登录ECS，可参考<a href="https://www.ocftcloud.com/ssr/help/compute/ecs/Quick_Start.Windows_Quick_Start.Login_Instance" target="_blank">登录Windows云主机</a>。</p> <p>2.&nbsp; 下载并安装MySQL-Front客户端，<a href="http://www.mysqlfront.de/" target="_blank">下载地址</a>。</p> <p>3.&nbsp; 启动MySQL-Front客户端。</p> <p>4.&nbsp; 输入以下内容，连接DRDS实例。</p> <table border="1" cellpadding="0" cellspacing="0" style="width:606px"> <tbody> <tr> <td style="background-color:#ededed; vertical-align:top; width:83px"> <p><strong>配置项</strong></p> </td> <td style="background-color:#ededed; vertical-align:top; width:517px"> <p><strong>说明</strong></p> </td> </tr> <tr> <td style="vertical-align:top; width:83px"> <p>名称</p> </td> <td style="vertical-align:top; width:517px"> <p>连接数据库的任务名称，如果不填写，默认采用<strong>主机</strong>名称。</p> </td> </tr> <tr> <td style="vertical-align:top; width:83px"> <p>主机</p> </td> <td style="vertical-align:top; width:517px"> <p>DRDS实例的访问域名。</p> <p><img src="https://obs-cn-shanghai.ocftcloud.com/pacloud/20201906135143-114e7ca7951a.png" style="height:26px; margin:0px; width:65px" />：可在目标DRDS实例的<strong>基本信息</strong>页面查询，可参考<a href="https://www.ocftcloud.com/ssr/help/database/DRDS/manual.Instance_Management.Configuration_Management.View_Instance" target="_blank">查看常规实例基本信息</a>。</p> </td> </tr> <tr> <td style="vertical-align:top; width:83px"> <p>端口</p> </td> <td style="vertical-align:top; width:517px"> <p>DRDS实例的端口号。</p> <p><img src="https://obs-cn-shanghai.ocftcloud.com/pacloud/20201906135143-114e7ca7951a.png" style="height:26px; margin:0px; width:65px" />：可在目标DRDS实例的<strong>基本信息</strong>页面查询，可参考<a href="https://www.ocftcloud.com/ssr/help/database/DRDS/manual.Instance_Management.Configuration_Management.View_Instance" target="_blank">查看常规实例基本信息</a>。</p> </td> </tr> <tr> <td style="vertical-align:top; width:83px"> <p>连接类型</p> </td> <td style="vertical-align:top; width:517px"> <p>MySQL-Front客户端支持：</p> <p>&bull;&nbsp; 内建</p> <p>&bull;&nbsp; 动态库</p> <p>&bull;&nbsp; HTTP隧道</p> </td> </tr> <tr> <td style="vertical-align:top; width:83px"> <p>用户</p> </td> <td style="vertical-align:top; width:517px"> <p>DRDS逻辑库的目标用户名。</p> <p><img src="https://obs-cn-shanghai.ocftcloud.com/pacloud/20201906135143-114e7ca7951a.png" style="height:26px; margin:0px; width:65px" />：可在目标DRDS实例的<strong>账号管理</strong>页面查询，可参考<a href="https://www.ocftcloud.com/ssr/help/database/DRDS/quick_start.Create_User" target="_blank">创建用户</a>。</p> </td> </tr> <tr> <td style="vertical-align:top; width:83px"> <p>密码</p> </td> <td style="vertical-align:top; width:517px"> <p>指定用户的密码。</p> </td> </tr> <tr> <td style="vertical-align:top; width:83px"> <p>数据库</p> </td> <td style="vertical-align:top; width:517px"> <p>需要连接的数据库名称，可为空。</p> </td> </tr> </tbody> </table> <p>5.&nbsp; 单击<strong>确定</strong>。</p> <p>6.&nbsp; 在<strong>连接管理</strong>页面，选择目标任务，单击<strong>打开</strong>。</p> <p><span style="font-size:18px"><strong>执行结果</strong></span></p> <p>成功连接DRDS实例。</p>