<p>This article describes how to install a MySQL client on the ECS in Windows operating system and access an RDS MySQL instance via MySQL client.</p> <p><span style="font-size:18px"><strong>Prerequisites</strong></span></p> <ol> <li>You have successfully bound an account and a database. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/Getting_Started.RDS_MySQL.Binding_Account" target="_blank">Authorize Permission of Account and Database</a>.</li> <li>You have successfully created an ECS and the instance is in the status of running. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/Getting_Started.RDS_MySQL.Create_ECS" target="_blank">Create an ECS</a>. Select a windows image when you create the ECS.</li> <li>You have successfully opened a whitelist. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/Getting_Started.RDS_MySQL.Create_Whitelist" target="_blank">Open a Whitelist</a>.</li> </ol> <p><span style="font-size:18px"><strong>Procedures</strong></span></p> <p>1.&nbsp; Log in to a Windows&nbsp;ECS instance. For more information, see&nbsp;<a href="http://pinganyun.com/ssr/help/compute/ecs/Quick_Start.Windows_Quick_Start.Login_Instance" target="_blank">Log In to Instance</a>.&nbsp;</p> <p>2.&nbsp; Download and install a MySQL-Front client. For more information, see <a href="http://www.mysqlfront.de/" target="_blank">Download Site</a>.</p> <p>3.&nbsp; Start MySQL-Front client.</p> <p>4.&nbsp; Enter the following content to connect to an RDS MySQL instance.</p> <table border="1" cellpadding="0" cellspacing="0"> <tbody> <tr> <td style="background-color:#ededed; vertical-align:top; width:140px"> <p><strong>Configuration item</strong></p> </td> <td style="background-color:#ededed; vertical-align:top; width:648px"> <p><strong>Description</strong></p> </td> </tr> <tr> <td style="vertical-align:top; width:140px"> <p>Name</p> </td> <td style="vertical-align:top; width:648px"> <p>The task name of connecting database. If it is not filled in, the system will use the <strong>server</strong> name by default.</p> </td> </tr> <tr> <td style="vertical-align:top; width:140px"> <p>Server</p> </td> <td style="vertical-align:top; width:648px"> <p>Domain name of an RDS MySQL instance</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200207141545-163329069f3b.png" style="height:22px; margin:0px; width:90px" />: It can be viewed on Basic Information page of the target RDS MySQL instance. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_MySQL.Instance_Management.View_Instance.View_Common_Instance" target="_blank">View Basic Information of a General Instance</a>.</p> </td> </tr> <tr> <td style="vertical-align:top; width:140px"> <p>Port</p> </td> <td style="vertical-align:top; width:648px"> <p>The port of an RDS MySQL instance.</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200207141545-163329069f3b.png" style="height:22px; margin:0px; width:90px" />: It can be viewed on Basic Information page of the target RDS MySQL instance. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_MySQL.Instance_Management.View_Instance.View_Common_Instance" target="_blank">View Basic Information of a General Instance</a>.</p> </td> </tr> <tr> <td style="vertical-align:top; width:140px"> <p>Connection type</p> </td> <td style="vertical-align:top; width:648px"> <p>MySQL-Front client supports:</p> <p>&bull;&nbsp; Built-in</p> <p>&bull;&nbsp; Dynamic library</p> <p>&bull;&nbsp; HTTP channel</p> </td> </tr> <tr> <td style="vertical-align:top; width:140px"> <p>User</p> </td> <td style="vertical-align:top; width:648px"> <p>Target username of RDS MySQL database</p> <p><img src="https://obs-cn-shanghai.yun.pingan.com/pcp-portal/20200207141545-163329069f3b.png" style="height:22px; margin:0px; width:90px" />: It can be viewed on <strong>Account</strong> tab of the target RDS MySQL instance. For more information, see <a href="http://pinganyun.com/ssr/help/database/RDS/User_Guide_RDS_MySQL.Account.Create_Account" target="_blank">Create an Account</a>.</p> </td> </tr> <tr> <td style="vertical-align:top; width:140px"> <p>Password</p> </td> <td style="vertical-align:top; width:648px"> <p>Password of the designated user.</p> </td> </tr> <tr> <td style="vertical-align:top; width:140px"> <p>Database</p> </td> <td style="vertical-align:top; width:648px"> <p>Name of database that needs to be connected. It can be blank.</p> </td> </tr> </tbody> </table> <p>5.&nbsp; Click <strong>OK</strong>.</p> <p>6.&nbsp; On <strong>Open Connection</strong> page, select the target task and click <strong>Open</strong>.</p> <p><span style="font-size:18px"><strong>Result</strong></span></p> <p>RDS MySQL database is successfully connected.</p>