Centos6.8通过yum安装mysql5.7

我就是我 2022-05-19 22:48 235阅读 0赞

## 1.安装mysql的yum源 ##

a.下载配置mysql的yum源的rpm包

![861438-20170216123529832-2052463085.png][]

![861438-20170216123543004-2096719896.png][]

![861438-20170216123553738-621605405.png][]

根据上面3张图片中的操作下载下来的rpm文件可以通过如下命令获取：

wget https://dev.mysql.com/get/mysql57-community-release-el6-9.noarch.rpm

b.安装用来配置mysql的yum源的rpm包

rpm -Uvh mysql57-community-release-el6-9.noarch.rpm

或

yum localinstall -y mysql57-community-release-el6-9.noarch.rpm

安装成功后在/etc/yum.repos.d/下会多出几个mysql的yum源的配置，如下：

![861438-20170216123827597-1522889001.png][]

## 2.安装mysql ##

yum install mysql-community-server

## 3.开启mysql服务 ##

service mysqld start

![861438-20170216141801035-719809266.png][]

mysql安装成功后创建的超级用户`'root'@'localhost'的密码会被存储在``/var/log/mysqld.log，可以使用如下命令查看密码`

grep 'temporary password' /var/log/mysqld.log

![861438-20170216141901644-178079478.png][]

`使用mysql生成的`'root'@'localhost'用户`和密码登录数据库，并修改` 其`密码，具体命令`

shell> mysql -uroot -p

![861438-20170216141955597-1925417713.png][]

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'MyNewPass4!';

![861438-20170216142024941-1950751960.png][]

# #

## 4.开启远程连接 ##

设置iptables开放3306端口

vi /etc/sysconfig/iptables

![861438-20170216142131629-706709852.png][]

如果此时使用telnet远程登录mysql服务会出错：

![861438-20170216142210660-37659859.png][]

解决此问题的方法为：

将localhost改成%

进入mysql的BIN目录

<table style="border-spacing:0px;width:620px;border:1px solid rgb(192,192,192);"> 
 <tbody> 
  <tr> 
   <td style="border-color:rgb(192,192,192);border-collapse:collapse;">&nbsp;代码如下</td> 
   <td align="center" style="border-color:rgb(192,192,192);border-collapse:collapse;">&nbsp;</td> 
  </tr> 
  <tr> 
   <td colspan="2" style="border-color:rgb(192,192,192);border-collapse:collapse;"><p>mysql -u root -p</p><p>mysql&gt;use mysql;</p><p>mysql&gt;update user set host =’%'where user =’root’;</p><p>mysql&gt;flush privileges;</p><p>&nbsp;</p></td> 
  </tr> 
 </tbody> 
</table>

具体分析

1、在本机登入mysql后，更改“mysql”数据库里的“user”表里的“host”项，从”localhost”改为'%'。

<table style="border-spacing:0px;width:620px;border:1px solid rgb(192,192,192);"> 
 <tbody> 
  <tr> 
   <td style="border-color:rgb(192,192,192);border-collapse:collapse;">&nbsp;代码如下</td> 
   <td align="center" style="border-color:rgb(192,192,192);border-collapse:collapse;">&nbsp;</td> 
  </tr> 
  <tr> 
   <td colspan="2" style="border-color:rgb(192,192,192);border-collapse:collapse;">mysql&gt;<br>mysql&gt;use mysql;<br>mysql&gt;select 'host' from user where user='root';&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<br></td> 
  </tr> 
 </tbody> 
</table>

\#查看mysql库中的user表的host值（即可进行连接访问的主机/IP名称）

<table style="border-spacing:0px;width:446px;font-size:14px;border:1px solid rgb(192,192,192);color:rgb(0,0,0);font-family:Verdana, Arial, Helvetica, sans-serif;background-color:rgb(255,255,255);"> 
 <tbody> 
  <tr> 
   <td colspan="1" style="border-color:rgb(192,192,192);border-collapse:collapse;">&nbsp;代码如下</td> 
   <td colspan="1" style="border-color:rgb(192,192,192);border-collapse:collapse;">&nbsp;</td> 
  </tr> 
  <tr> 
   <td colspan="2" style="border-color:rgb(192,192,192);border-collapse:collapse;">mysql&gt;update user set host = '%' where user ='root';</td> 
  </tr> 
 </tbody> 
</table>

\#修改host值（以通配符%的内容增加主机/IP地址，当然也可以直接增加某个特定IP地址，如果执行update语句时出现ERROR 1062 (23000): Duplicate entry '%-root' for key 'PRIMARY' 错误，需要select host from user where user = 'root';  
查看一下host是否已经有了%这个值，如果有了直接执行下面的flush privileges;即可）

<table style="border-spacing:0px;font-size:14px;border:1px solid rgb(192,192,192);color:rgb(0,0,0);font-family:Verdana, Arial, Helvetica, sans-serif;background-color:rgb(255,255,255);"> 
 <tbody> 
  <tr> 
   <td colspan="1" style="border-color:rgb(192,192,192);border-collapse:collapse;">&nbsp;代码如下</td> 
   <td colspan="1" style="border-color:rgb(192,192,192);border-collapse:collapse;">&nbsp;</td> 
  </tr> 
  <tr> 
   <td colspan="2" style="border-color:rgb(192,192,192);border-collapse:collapse;"><p>mysql&gt;flush privileges;<br>mysql&gt;select host,user from user where user='root';<br>mysql&gt;quit</p></td> 
  </tr> 
 </tbody> 
</table>

再次尝试连接后，成功：

![861438-20170216142811613-1005584245.png][]

[861438-20170216123529832-2052463085.png]: /images/20220520/a702d11512404c4ab992642a76b94ebb.png
[861438-20170216123543004-2096719896.png]: /images/20220520/b7a4d24f346c4ab1bde49d7d7f7dbf4f.png
[861438-20170216123553738-621605405.png]: /images/20220520/4a14017b5b7a4ddf9fe02a16d2fdb379.png
[861438-20170216123827597-1522889001.png]: /images/20220520/e90533cfcd8044b9af814c2755a12b27.png
[861438-20170216141801035-719809266.png]: /images/20220520/be7109658e444c119b1dd8354d3d0bf4.png
[861438-20170216141901644-178079478.png]: /images/20220520/e6d21dbbb29e4e3d833a076013686ecd.png
[861438-20170216141955597-1925417713.png]: /images/20220520/3cabbb0e8f3d418db32777358f983216.png
[861438-20170216142024941-1950751960.png]: /images/20220520/1cbe6ad00b7043dd83917a27c66c12c9.png
[861438-20170216142131629-706709852.png]: /images/20220520/c6ed9961da5e4a2a8f450e028e5c7dc7.png
[861438-20170216142210660-37659859.png]: /images/20220520/f843e4a6148e4328bca51ea2fad77d28.png
[861438-20170216142811613-1005584245.png]: /images/20220520/259fb628d3d6412dbfdb92da9147514f.png