详解腾讯云CentOS7.0使用yum安装mysql及使用遇到的问题
<p>背景：</p>
<p>
今天才申请了腾讯云+校园计划的1元服务器，安装了Centos7.0，在安装MySQL的时候，使用yum list | grep mysql 来查找yum源中是否有mysql，结果如下：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_836442">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># yum list | grep mysql</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">akonadi-mysql.x86_64 1.9.2-4.el7 base </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">apr-util-mysql.x86_64 1.5.2-6.el7 base </code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">mysql-proxy.x86_64 0.8.5-2.el7 epel </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">mysql-proxy-devel.x86_64 0.8.5-2.el7 epel </code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">mysql-router.x86_64 2.0.2-1.el7 mysql-tools-community</code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">mysql-router-debuginfo.x86_64 2.0.2-1.el7 mysql-tools-community</code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">mysql-utilities.noarch 1.5.6-1.el7 mysql-tools-community</code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">mysql-utilities-extra.noarch 1.5.6-1.el7 mysql-tools</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash plain">mysqlreport.noarch 3.5-11.el7 epel </code>
</div>
<div class="line number11 index10 alt2">
<code class="bash plain">mysqltuner.noarch 1.2.0-7.el7 epel </code>
</div>
<div class="line number12 index11 alt1">
<code class="bash plain">省略部分内容。。。。</code>
</div>
<div class="line number13 index12 alt2">
<code class="bash plain"></code><code class="bash comments">#</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
总之是看不到mysql-server的影子，（PS:据说Centos7.0的源中暂时还没有mysql，但是相同版本的Centos在阿里云是可以直接使用yum install mysql-server 来直接安装mysql的）</p>
<p>
于是找了一些mysql的安装源，安装过程如下：</p>
<p>
<strong>安装过程：</strong></p>
<p>
为了解决这个问题，我们要先下载mysql的repo源。</p>
<p>
1、下载mysql的repo源</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_188895">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">$ wget http:</code><code class="bash plain">//repo</code><code class="bash plain">.mysql.com</code><code class="bash plain">/mysql-community-release-el7-5</code><code class="bash plain">.noarch.rpm</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
2、安装mysql-community-release-el7-5.noarch.rpm包</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_989925">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">$ </code><code class="bash functions">sudo</code> <code class="bash plain">rpm -ivh mysql-community-release-el7-5.noarch.rpm</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
安装这个包后，会获得两个mysql的yum repo源：</p>
<p>
/etc/yum.repos.d/mysql-community.repo和/etc/yum.repos.d/mysql-community-source.repo。</p>
<p>
3、安装mysql</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_308936">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">$ </code><code class="bash functions">sudo</code> <code class="bash plain">yum </code><code class="bash functions">install</code> <code class="bash plain">mysql-server</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
这个过程中就会看到有mysql的软件包存在：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_830074">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
<div class="line number7 index6 alt2">
7</div>
<div class="line number8 index7 alt1">
8</div>
<div class="line number9 index8 alt2">
9</div>
<div class="line number10 index9 alt1">
10</div>
<div class="line number11 index10 alt2">
11</div>
<div class="line number12 index11 alt1">
12</div>
<div class="line number13 index12 alt2">
13</div>
<div class="line number14 index13 alt1">
14</div>
<div class="line number15 index14 alt2">
15</div>
<div class="line number16 index15 alt1">
16</div>
<div class="line number17 index16 alt2">
17</div>
<div class="line number18 index17 alt1">
18</div>
<div class="line number19 index18 alt2">
19</div>
<div class="line number20 index19 alt1">
20</div>
<div class="line number21 index20 alt2">
21</div>
<div class="line number22 index21 alt1">
22</div>
<div class="line number23 index22 alt2">
23</div>
<div class="line number24 index23 alt1">
24</div>
<div class="line number25 index24 alt2">
25</div>
<div class="line number26 index25 alt1">
26</div>
<div class="line number27 index26 alt2">
27</div>
<div class="line number28 index27 alt1">
28</div>
<div class="line number29 index28 alt2">
29</div>
<div class="line number30 index29 alt1">
30</div>
<div class="line number31 index30 alt2">
31</div>
<div class="line number32 index31 alt1">
32</div>
<div class="line number33 index32 alt2">
33</div>
<div class="line number34 index33 alt1">
34</div>
<div class="line number35 index34 alt2">
35</div>
<div class="line number36 index35 alt1">
36</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain"></code><code class="bash comments"># sudo yum install mysql-server</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">已加载插件：fastestmirror, langpacks </code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">| 2.5 kB 00:00:00 </code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">mysql-tools-community | 2.5 kB 00:00:00 </code>
</div>
<div class="line number5 index4 alt2">
<code class="bash plain">mysql56-community | 2.5 kB 00:00:00 </code>
</div>
<div class="line number6 index5 alt1">
<code class="bash plain">(1</code><code class="bash plain">/3</code><code class="bash plain">): mysql-connectors-community</code><code class="bash plain">/x86_64/primary_db</code> <code class="bash plain">| 8.6 kB 00:00:00 </code>
</div>
<div class="line number7 index6 alt2">
<code class="bash plain">(2</code><code class="bash plain">/3</code><code class="bash plain">): mysql-tools-community</code><code class="bash plain">/x86_64/primary_db</code> <code class="bash plain">| 22 kB 00:00:00 </code>
</div>
<div class="line number8 index7 alt1">
<code class="bash plain">(3</code><code class="bash plain">/3</code><code class="bash plain">): mysql56-community</code><code class="bash plain">/x86_64/primary_db</code> <code class="bash plain">| 109 kB 00:00:01 </code>
</div>
<div class="line number9 index8 alt2">
<code class="bash plain">Loading mirror speeds from cached hostfile</code>
</div>
<div class="line number10 index9 alt1">
<code class="bash spaces"> </code><code class="bash plain">* base: mirrors.sina.cn</code>
</div>
<div class="line number11 index10 alt2">
<code class="bash spaces"> </code><code class="bash plain">* extras: mirrors.sina.cn</code>
</div>
<div class="line number12 index11 alt1">
<code class="bash spaces"> </code><code class="bash plain">* updates: mirrors.sina.cn</code>
</div>
<div class="line number13 index12 alt2">
<code class="bash plain">正在解决依赖关系</code>
</div>
<div class="line number14 index13 alt1">
<code class="bash plain">--> 正在检查事务</code>
</div>
<div class="line number15 index14 alt2">
</div>
<div class="line number16 index15 alt1">
<code class="bash plain">省略内容。。。</code>
</div>
<div class="line number17 index16 alt2">
</div>
<div class="line number18 index17 alt1">
<code class="bash plain">依赖关系解决</code>
</div>
<div class="line number19 index18 alt2">
<code class="bash plain">=================================================================================================================</code>
</div>
<div class="line number20 index19 alt1">
<code class="bash spaces"> </code><code class="bash plain">Package 架构 版本 源 大小</code>
</div>
<div class="line number21 index20 alt2">
<code class="bash plain">=================================================================================================================</code>
</div>
<div class="line number22 index21 alt1">
<code class="bash plain">正在安装:</code>
</div>
<div class="line number23 index22 alt2">
<code class="bash spaces"> </code><code class="bash plain">mysql-community-libs x86_64 5.6.27-2.el7 mysql56-community 2.0 M</code>
</div>
<div class="line number24 index23 alt1">
<code class="bash spaces"> </code><code class="bash plain">替换 mariadb-libs.x86_64 1:5.5.44-1.el7_1</code>
</div>
<div class="line number25 index24 alt2">
<code class="bash spaces"> </code><code class="bash plain">mysql-community-server x86_64 5.6.27-2.el7 mysql56-community 58 M</code>
</div>
<div class="line number26 index25 alt1">
<code class="bash plain">为依赖而安装:</code>
</div>
<div class="line number27 index26 alt2">
<code class="bash spaces"> </code><code class="bash plain">mysql-community-client x86_64 5.6.27-2.el7 mysql56-community 19 M</code>
</div>
<div class="line number28 index27 alt1">
<code class="bash spaces"> </code><code class="bash plain">mysql-community-common x86_64 5.6.27-2.el7 mysql56-community 256 k</code>
</div>
<div class="line number29 index28 alt2">
<code class="bash spaces"> </code><code class="bash plain">numactl-libs x86_64 2.0.9-5.el7_1 </code>
</div>
<div class="line number30 index29 alt1">
</div>
<div class="line number31 index30 alt2">
<code class="bash plain">事务概要</code>
</div>
<div class="line number32 index31 alt1">
<code class="bash plain">=================================================================================================================</code>
</div>
<div class="line number33 index32 alt2">
<code class="bash plain">安装 2 软件包 (+9 依赖软件包)</code>
</div>
<div class="line number34 index33 alt1">
</div>
<div class="line number35 index34 alt2">
<code class="bash plain">总下载量：80 M</code>
</div>
<div class="line number36 index35 alt1">
<code class="bash plain">Is this ok : y</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
下边的安装和其他安装一样，</p>
<p>
根据步骤安装就可以了，不过安装完成后，没有密码，需要重置密码。</p>
<p>
4、重置密码</p>
<p>
重置密码前，首先要登录</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_485225">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">$ mysql -u root</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
登录时有可能报这样的错：ERROR 2002 (HY000): Can‘t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock‘ (2)，原因是/var/lib/mysql的访问权限问题。下面的命令把/var/lib/mysql的拥有者改为当前用户：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_348102">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">$ </code><code class="bash functions">sudo</code> <code class="bash functions">chown</code> <code class="bash plain">-R mysql:mysql </code><code class="bash plain">/var/lib/mysql</code> <code class="bash comments">#这里的mysql是用户名（需要设置用户组合用户）</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
然后，重启服务：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_347762">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">$ service mysqld restart</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
接下来登录重置密码：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_346896">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">$ mysql -u root</code>
</div>
<div class="line number2 index1 alt1">
<code class="bash plain">mysql > use mysql;</code>
</div>
<div class="line number3 index2 alt2">
<code class="bash plain">mysql > update user </code><code class="bash functions">set</code> <code class="bash plain">password=password(</code><code class="bash string">'xu827928'</code><code class="bash plain">) where user=</code><code class="bash string">'root'</code><code class="bash plain">;</code>
</div>
<div class="line number4 index3 alt1">
<code class="bash plain">mysql > </code><code class="bash functions">exit</code><code class="bash plain">;</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
5、开放3306端口(可以不用设置)</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_307450">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">$ </code><code class="bash functions">sudo</code> <code class="bash plain">vim </code><code class="bash plain">/etc/sysconfig/iptables</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
添加以下内容：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_654939">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
保存后重启防火墙：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterbash" id="highlighter_660517">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="bash plain">$ </code><code class="bash functions">sudo</code> <code class="bash plain">service iptables restart</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
这样从其它客户机也可以连接上mysql服务了。</p>
<p>
6、修改权限可以使其他机器登录：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_540278">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql>mysql -h localhost -u root //这样应该可以进入MySQL服务器 </code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">mysql></code><code class="sql keyword">GRANT</code> <code class="sql color1">ALL</code> <code class="sql keyword">PRIVILEGES</code> <code class="sql keyword">ON</code> <code class="sql plain">*.* </code><code class="sql keyword">TO</code> <code class="sql string">'root'</code><code class="sql plain">@</code><code class="sql string">'%'</code> <code class="sql keyword">WITH</code> <code class="sql keyword">GRANT</code> <code class="sql keyword">OPTION</code> <code class="sql plain">//赋予任何主机访问数据的权限 </code>
</div>
<div class="line number3 index2 alt2">
<code class="sql plain">mysql>FLUSH </code><code class="sql keyword">PRIVILEGES</code> <code class="sql plain">//修改生效 </code>
</div>
<div class="line number4 index3 alt1">
<code class="sql plain">mysql>EXIT //退出MySQL服务器</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
使用时遇到的问题</p>
<p>
（1）Java.sql.SQLException: Access denied for user ‘root'@'localhost' (using password:YES)</p>
<div class="jb51code">
<div>
<div class="syntaxhighlighterplain" id="highlighter_112267">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
<div class="line number6 index5 alt1">
6</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="plain plain">java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) </code>
</div>
<div class="line number2 index1 alt1">
<code class="plain plain">at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946) </code>
</div>
<div class="line number3 index2 alt2">
<code class="plain plain">at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2870)</code>
</div>
<div class="line number4 index3 alt1">
<code class="plain plain">at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:812) </code>
</div>
<div class="line number5 index4 alt2">
<code class="plain plain">at com.mysql.jdbc.MysqlIO.secureAuth411(MysqlIO.java:3269)</code>
</div>
<div class="line number6 index5 alt1">
<code class="plain plain">at com.mysql.jdbc.MysqlIO.doHandshake(MysqlIO.java:1182)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
问题的场景是：在命令行模式下用户名和密码都是正确的但是就是出现登陆不了授权失败的问题。</p>
<p>
解决方法：</p>
<p>
进入MySQL命令台：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_589006">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">select</code> <code class="sql color2">user</code><code class="sql plain">,</code><code class="sql keyword">password</code><code class="sql plain">,host </code><code class="sql keyword">from</code> <code class="sql plain">mysql.</code><code class="sql color2">user</code><code class="sql plain">;</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
<img title="详解腾讯云CentOS7.0使用yum安装mysql及使用遇到的问题" alt="详解腾讯云CentOS7.0使用yum安装mysql及使用遇到的问题" src="https://zhuji.jb51.net/uploads/img/202305/111635627df1d0b5fc1d6ca474b84e72.jpg"></p>
<p>
可以看出该表显示的倒数第二行为：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_125612">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">+</code><code class="sql comments">--------+-------------------------------------------+--------------------+</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">| </code><code class="sql color2">user</code> <code class="sql plain">| </code><code class="sql keyword">password</code> <code class="sql plain">| host |</code>
</div>
<div class="line number3 index2 alt2">
<code class="sql plain">+</code><code class="sql comments">--------+-------------------------------------------+--------------------+</code>
</div>
<div class="line number4 index3 alt1">
<code class="sql plain">| root | | % |</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
可以看出在root用户下的任何主机是没有password的，因此可以采取两种方式，在远端使用的时候没有密码，显然是不安全的，然后就是为其在远端访问的时候设置密码。步骤如下：</p>
<div class="jb51code">
<div>
<div class="syntaxhighlightersql" id="highlighter_795703">
<div class="toolbar">
<span>?</span>
</div>
<table border="0" cellpadding="0" cellspacing="0"><tbody><tr>
<td class="gutter">
<div class="line number1 index0 alt2">
1</div>
<div class="line number2 index1 alt1">
2</div>
<div class="line number3 index2 alt2">
3</div>
<div class="line number4 index3 alt1">
4</div>
<div class="line number5 index4 alt2">
5</div>
</td>
<td class="code">
<div class="container">
<div class="line number1 index0 alt2">
<code class="sql plain">mysql> </code><code class="sql keyword">grant</code> <code class="sql color1">all</code> <code class="sql keyword">privileges</code> <code class="sql keyword">on</code> <code class="sql plain">*.* </code><code class="sql keyword">to</code> <code class="sql plain">root@</code><code class="sql string">"%"</code> <code class="sql plain">identified </code><code class="sql keyword">by</code> <code class="sql string">"your password"</code><code class="sql plain">;</code>
</div>
<div class="line number2 index1 alt1">
<code class="sql plain">Query OK, 0 </code><code class="sql keyword">rows</code> <code class="sql plain">affected (0.00 sec)</code>
</div>
<div class="line number3 index2 alt2">
</div>
<div class="line number4 index3 alt1">
<code class="sql plain">mysql> flush </code><code class="sql keyword">privileges</code><code class="sql plain">;</code>
</div>
<div class="line number5 index4 alt2">
<code class="sql plain">Query OK, 0 </code><code class="sql keyword">rows</code> <code class="sql plain">affected (0.00 sec)</code>
</div>
</div>
</td>
</tr></tbody></table>
</div>
</div>
<div class="codetool" id="codetool">
<div class="code_n">
<textarea></textarea>
</div>
</div>
</div>
<p>
这相当于是给IP-xxx.xxx.xxx.xxx赋予了所有的权限，包括远程访问权限。</p>
<p>
这样就可以为其设置密码，然后就可以使用密码进行登录。</p>
<p>
以上就是本文的全部内容，希望对大家的学习有所帮助，也希望大家多多支持服务器之家。</p>
<p>
原文链接：http://blog.csdn.net/xlgen157387/article/details/49964557</p>
頁:
[1]