<p class="shortdesc">本文主要介绍如何在Linux操作系统的ECS上安装MySQL客户端，并通过MySQL客户端访问RDS-MySQL实例。</p> <section class="section prereq" id="Linux__prereq_dtp_2ky_gsb"><div class="tasklabel"><h2 class="doc-tairway">前提条件</h2></div> <ol class="ol" id="Linux__ol_ucg_fky_gsb"> <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>，且实例处于运行中。</li> <li class="li">您已成功开通白名单，可参考<a class="xref" href="/ssr/help/database/MySQL/quick.CWhitelist" target="_blank" rel="external noopener">开通白名单</a>。</li> </ol> <div class="note important note_important" id="Linux__note_sqn_hsm_dtb"><span class="note__title">重要：</span> <ol class="ol" id="Linux__ol_wdb_hky_gsb"> <li class="li">若需要执行SSL加密功能，MySQL客户端的版本需要大于等于5.6.38。</li> <li class="li">ECS的操作系统请选择CentOS 7.x、RedHat Linux 7.x、Oracle Linux 7.x及以上的版本。</li> </ol> </div> </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_Linux_Instance.Console_Remote_Login" target="_blank" rel="external noopener">登录Linux云主机</a>。</span> </li><li class="li step stepexpand"> <span class="ph cmd">执行以下命令打开xxx.repo文件。</span> <div class="itemgroup info"> <div class="note important note_important"><span class="note__title">重要：</span> <p class="p">xxx：文件名称，您可以根据实际情况自定义。</p> </div> <pre class="pre codeblock"><code>cd /etc/yum.repos.d vim xxx.repo </code></pre> </div> </li><li class="li step stepexpand"> <span class="ph cmd">在xxx.repo文件中增加以下内容。</span> <div class="itemgroup info"> <div class="note important note_important"><span class="note__title">重要：</span> <p class="p">若MySQL的版本是8.0，需要使用MySQL 8.0的客户端进行访问。同时将mysql57-community-el7替换为mysql80-community-el7。</p> </div> <pre class="pre codeblock"><code>[MySQL] //您可以根据实际情况自定义名称 name=mysql57-community-el7 baseurl=http://mirrors.yun.paic.com.cn:4048/mysql/yum/mysql57-community-el7/ enabled=1 gpgcheck=0 </code></pre> </div> </li><li class="li step stepexpand"> <span class="ph cmd">执行以下命令，更新yum源。</span> <div class="itemgroup info"> <pre class="pre codeblock"><code>yum clean all && yum makecache</code></pre> </div> </li><li class="li step stepexpand"> <span class="ph cmd">执行以下命令，屏蔽默认的MySQL软件。</span> <div class="itemgroup info"> <pre class="pre codeblock"><code>yum -qy module disable mysql</code></pre> </div> </li><li class="li step stepexpand"> <span class="ph cmd">执行以下命令，安装MySQL客户端。</span> <div class="itemgroup info"> <pre class="pre codeblock"><code>yum install mysql</code></pre> </div> </li><li class="li step stepexpand"> <span class="ph cmd">执行以下命令，连接RDS-MySQL实例。</span> <div class="itemgroup info"> <ul class="ul" id="Linux__ul_nr4_qky_gsb"> <li class="li"> <p class="p">指定数据库连接：</p> <pre class="pre codeblock"><code>mysql -h<em class="ph i">Domain-name</em> -u<em class="ph i">Mysql_Account</em> -D<em class="ph i">Database-name</em> -P<em class="ph i">Port</em> -p<em class="ph i">Password</em></code></pre> </li> <li class="li"> <p class="p">不指定数据库连接，会连接至默认的系统数据库。</p> <pre class="pre codeblock"><code>mysql -h<em class="ph i">Domain-name</em> -u<em class="ph i">Mysql_Account</em> -P<em class="ph i">Port</em> -p<em class="ph i">Password</em> use <em class="ph i">Database-name </em></code></pre> </li> </ul> <div class="note important note_important" id="Linux__note_zpx_btz_jsb"><span class="note__title">重要：</span> <p class="p">各参数说明如下，若需了解更多实例相关信息可参考<a class="xref" href="/ssr/help/database/MySQL/Guide.IM.ViewIns.View_Common_Instance" target="_blank" rel="external noopener">查看实例基本信息</a>。</p> <ul class="ul" id="Linux__ul_jby_sky_gsb"> <li class="li">-h<em class="ph i">Domain-Name</em>：RDS-MySQL实例的<span class="ph uicontrol">访问域名</span>。</li> <li class="li">-u<em class="ph i">Mysql_Account</em>：创建的账号名。</li> <li class="li">-D<em class="ph i">Database-name</em>：创建的数据库名。</li> <li class="li">-P<em class="ph i">Port</em>：RDS-MySQL实例的<span class="ph uicontrol">连接端口</span>。</li> <li class="li">-p<em class="ph i">Password</em>：创建账号时设置的<span class="ph uicontrol">密码</span>。</li> </ul> </div> </div> </li></ol></section> <section class="section result"><div class="tasklabel"><h2 class="doc-tairway">执行结果</h2></div> <p class="p">成功连接RDS-MySQL实例。</p> <ul class="ul"> <li class="li">指定数据库连接<p class="p"><img class="image" id="Linux__image_hj3_5vm_hsb" src="https://obs-cn-shanghai.fincloud.pinganyun.com/pacloud/20222410144209-14d2ecf29e68.png"></p></li> <li class="li">不指定数据库连接<p class="p"><img class="image" id="Linux__image_g3c_vvm_hsb" src="https://obs-cn-shanghai.fincloud.pinganyun.com/pacloud/20222410144209-182251f29f7d.png"></p></li> </ul> </section>