MySQL5.6之 rpm安装

朴灿烈づ我的快乐病毒、 2022-09-19 04:26 132阅读 0赞

以64位服务器为例：

（1）、到MySQL官网http://dev.mysql.com/downloads/mysql/ 下载MySQL-server-5.6.13-1.el6.x86\_64.rpm 和MySQL-client-5.6.15-1.el6.x86\_64.rpm

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-server-5.6.13-1.el6.x86\_64.rpm

wget http://dev.mysql.com/get/Downloads/MySQL-5.6/MySQL-client-5.6.13-1.el6.x86\_64.rpm

（2）、判断该服务器上是否有以rpm包安装的MySQL，有的话就用rpm-e 命令一个一个的删除，然后查找下一个残留的文件：

查找：rpm -qa | grep -i mysql

删除：rpm -e --nodeps MySQL-server-5.6.13-1.el6.x86\_64（--nodeps 防止互相依赖不能删除的情况）

查看有没有安装的MySQL服务：chkconfig --list | grep -i mysql

删除MySQL服务：chkconfig --del mysql

删除是否有分散MySQL文件夹，有则删除之：whereis mysql

（3）、安装MySQL

rpm -ivh MySQL-server-5.6.13-1.el6.x86\_64.rpm

rpm -ivh MySQL-client-5.6.13-1.el6.x86\_64.rpm

\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*\*

**安装Percona mysql的时候出现依赖包错误**

\[root@localhost upload\]\# rpm -ivh Percona-Server-server-56-5.6.27-rel76.0.el6.x86\_64.rpm

警告：Percona-Server-server-56-5.6.27-rel76.0.el6.x86\_64.rpm: 头V4 DSA/SHA1 Signature, 密钥 ID cd2efd2a: NOKEY

错误：依赖检测失败：

perl(Data::Dumper) 被 Percona-Server-server-56-5.6.27-rel76.0.el6.x86\_64 需要

**用yum安装perl提示已经安装**

\[root@localhost upload\]\# yum install perl

已加载插件：fastestmirror

Loading mirror speeds from cached hostfile

\* base: mirrors.163.com

\* extras: mirrors.163.com

\* updates: mirrors.163.com

软件包 4:perl-5.16.3-286.el7.x86\_64 已安装并且是最新版本

无须任何处理

** 网上查找资料得知需要安装的是autoconf**

\[root@localhost upload\]\# yum -y install autoconf

....

**安装通过**

\[root@localhost upload\]\# rpm -ivh Percona-Server-server-56-5.6.27-rel76.0.el6.x86\_64.rpm

警告：Percona-Server-server-56-5.6.27-rel76.0.el6.x86\_64.rpm: 头V4 DSA/SHA1 Signature, 密钥 ID cd2efd2a: NOKEY

准备中...                          \#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]

正在升级/安装...

1:Percona-Server-server-56-5.6.27-r\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\#\# \[100%\]

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>#<span style="color:#333333;">mysql 5.6之后</span>安装后生成的一个随机密码在 /root/.mysql_secret</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>13</code></td> 
   <td style="vertical-align:top;"><code>#启动 MySQL</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>14</code></td> 
   <td style="vertical-align:top;"><code>service mysql start</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>16</code></td> 
   <td style="vertical-align:top;"><code>#登录mysql</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>17</code></td> 
   <td style="vertical-align:top;"><code>mysql -u root -p</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>20</code></td> 
   <td style="vertical-align:top;"><code>SET PASSWORD=password(</code><code>'password'</code><code>);</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>22</code></td> 
   <td style="vertical-align:top;"><code>#添加一个可远程登录的帐号</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>23</code></td> 
   <td style="vertical-align:top;"><code>GRANT all privileges on *.* TO&nbsp;</code><code>'root'</code><code>@</code><code>'%'</code>&nbsp;<code>identified by&nbsp;</code><code>'password'</code>&nbsp;<code>WITH GRANT OPTION;</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>24</code></td> 
   <td style="vertical-align:top;"><code>FLUSH PRIVILEGES;</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>26</code></td> 
   <td style="vertical-align:top;"><code>SET PASSWORD FOR&nbsp;</code><code>'root'</code><code>@</code><code>'%'</code>&nbsp;<code>= PASSWORD(</code><code>'password'</code><code>);</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>31</code></td> 
   <td style="vertical-align:top;"><code>#可运行此脚本 进行生产服务器安全配置</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>32</code></td> 
   <td style="vertical-align:top;"><code>/usr/bin/mysql_secure_installation</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>35</code></td> 
   <td style="vertical-align:top;"><code>#Enter current password for root&nbsp; 输入root密码</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>36</code></td> 
   <td style="vertical-align:top;"><code>#Change the root password?&nbsp; 是否修改root的密码</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>37</code></td> 
   <td style="vertical-align:top;"><code>#Remove anonymous users?&nbsp; 是否删除匿名账号</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>38</code></td> 
   <td style="vertical-align:top;"><code>#Disallow root login remotely?&nbsp; 是否取消root用户远程登录</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>39</code></td> 
   <td style="vertical-align:top;"><code>#Remove test database and access to it?&nbsp; 是否删除test库和对test库的访问权限</code></td> 
  </tr> 
 </tbody> 
</table>

<table> 
 <tbody> 
  <tr> 
   <td style="vertical-align:top;"><code>40</code></td> 
   <td style="vertical-align:top;"><code>#Reload privilege tables now?&nbsp; 是否现在刷新授权表使修改生效</code></td> 
  </tr> 
 </tbody> 
</table>

（4）、默认安装的文件路径

basedir=/usr

datadir=/var/lib/mysql

默认的my-default.cnf文件在/usr/share/mysql路径下，将该文件复制到/etc目录下并命名为my.cnf

cp my-default.cnf /etc/my.cnf

（5）、根据自己服务器的需要，修改配置文件。

（6）、添加到系统自动启动

cp /usr/share/mysql/mysql.server /etc/init.d/mysql

chkconfig --add mysql

（7）、启动、关闭、重启MySQL服务进程

/etc/init.d/mysql start/stop/restart

（8）、查看MySQL进程

ps -ef | grep mysql

（9）、设置远程访问，修改防火墙配置文件：

vi /etc/sysconfig/iptables   
增加下面一行：   
\-A RH-Firewall-1-INPUT -m state --state NEW -m tcp -p tcp --dport 3306 -j ACCEPT

添加-A RH-Firewall-1-INPUT -m state –state NEW -m tcp -p tcp –dport 3306 -j ACCEPT（注意添加在-A RH-Firewall-1-INPUT -j REJECT –reject-with icmp-host-prohibited之前，否则可能导致规则不生效。是拒绝icmp访问，对于其它的报文返回一个主机禁止访问的错误 ）

配置后，重新启动iptable   
service iptables restart