首页 CentOS Centos MySQL 5.7 安装、升级详细教程

Centos MySQL 5.7 安装、升级详细教程

卸载当前的 MySQL #####查看当前 MySQL 版本: [root@coderknock ~]# mysql -Vmysql Ver 14.14 Distrib 5.1.73, for redhat-linux-gnu (i386) using readline 5.1 #####停止 MySQL 服务 [root@coderknock ~]# service mysqld stop

卸载当前的 MySQL

#####查看当前 MySQL 版本:

[root@coderknock ~]# mysql -V
mysql  Ver 14.14 Distrib 5.1.73,for redhat-linux-gnu (i386) using readline 5.1

#####停止 MySQL 服务

[root@coderknock ~]# service mysqld stop
Stopping mysqld:                                           [  OK  ]

#####备份数据【数据不重要可以忽略】

备份数据库,升级MySQL通常不会丢失数据,但保险起见,我们需要做这一步。输入命令:

[root@coderknock ~]# mysqldump -u xxx -h xxx -P 3306 -p --all-databases > databases.sql

#####卸载旧版本 MySQL

[root@coderknock ~]# yum remove mysql mysql-*
Loaded plugins: security
Setting up Remove Process
Resolving Dependencies
--> Running transaction check
---> Package mysql.i686 0:5.1.73-7.el6 will be erased
---> Package mysql-libs.i686 0:5.1.73-7.el6 will be erased
--> Processing Dependency: libmysqlclient.so.16 for package: 2:postfix-2.6.6-6.el6_7.1.i686
--> Processing Dependency: libmysqlclient.so.16 for package: perl-DBD-MySQL-4.013-3.el6.i686
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: 2:postfix-2.6.6-6.el6_7.1.i686
--> Processing Dependency: libmysqlclient.so.16(libmysqlclient_16) for package: perl-DBD-MySQL-4.013-3.el6.i686
--> Processing Dependency: mysql-libs for package: 2:postfix-2.6.6-6.el6_7.1.i686
---> Package mysql-server.i686 0:5.1.73-7.el6 will be erased
--> Running transaction check
---> Package perl-DBD-MySQL.i686 0:4.013-3.el6 will be erased
---> Package postfix.i686 2:2.6.6-6.el6_7.1 will be erased
--> Processing Dependency: /usr/sbin/sendmail for package: cronie-1.4.4-16.el6_8.2.i686
--> Processing Dependency: /usr/sbin/sendmail for package: redhat-lsb-core-4.0-7.el6.centos.i686
--> Running transaction check
---> Package cronie.i686 0:1.4.4-16.el6_8.2 will be erased
--> Processing Dependency: cronie = 1.4.4-16.el6_8.2 for package: cronie-anacron-1.4.4-16.el6_8.2.i686
---> Package redhat-lsb-core.i686 0:4.0-7.el6.centos will be erased
--> Running transaction check
---> Package cronie-anacron.i686 0:1.4.4-16.el6_8.2 will be erased
--> Processing Dependency: /etc/cron.d for package: crontabs-1.10-33.el6.noarch
--> Processing Dependency: /etc/cron.d for package: sysstat-9.0.4-31.el6.i686
--> Restarting Dependency Resolution with new changes.
--> Running transaction check
---> Package crontabs.noarch 0:1.10-33.el6 will be erased
---> Package sysstat.i686 0:9.0.4-31.el6 will be erased
--> Finished Dependency Resolution

Dependencies Resolved

=======================================================================================================================================================================================================
 Package                                     Arch                               Version                                       Repository                                                          Size
=======================================================================================================================================================================================================
Removing:
 mysql                                       i686                               5.1.73-7.el6                                  @base                                                              2.3 M
 mysql-libs                                  i686                               5.1.73-7.el6                                  @base                                                              3.9 M
 mysql-server                                i686                               5.1.73-7.el6                                  @base                                                               24 M
Removing for dependencies:
 cronie                                      i686                               1.4.4-16.el6_8.2                              @updates                                                           169 k
 cronie-anacron                              i686                               1.4.4-16.el6_8.2                              @updates                                                            38 k
 crontabs                                    noarch                             1.10-33.el6                                   @anaconda-CentOS-201311291201.i386/6.5                             2.4 k
 perl-DBD-MySQL                              i686                               4.013-3.el6                                   @base                                                              341 k
 postfix                                     i686                               2:2.6.6-6.el6_7.1                             @base                                                              9.3 M
 redhat-lsb-core                             i686                               4.0-7.el6.centos                              @anaconda-CentOS-201311291201.i386/6.5                              22 k
 sysstat                                     i686                               9.0.4-31.el6                                  @base                                                              804 k

Transaction Summary
=======================================================================================================================================================================================================
Remove       10 Package(s)

Installed size: 41 M
Is this ok [y/N]: y
Downloading Packages:
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Erasing    : mysql-server-5.1.73-7.el6.i686                                                                                                                                                     1/10 
warning: /var/log/mysqld.log saved as /var/log/mysqld.log.rpmsave
  Erasing    : redhat-lsb-core-4.0-7.el6.centos.i686                                                                                                                                              2/10 
/var/tmp/rpm-tmp.Y5QGjy: line 1: lsb_release: command not found
  Erasing    : mysql-5.1.73-7.el6.i686                                                                                                                                                            3/10 
  Erasing    : perl-DBD-MySQL-4.013-3.el6.i686                                                                                                                                                    4/10 
  Erasing    : sysstat-9.0.4-31.el6.i686                                                                                                                                                          5/10 
  Erasing    : crontabs-1.10-33.el6.noarch                                                                                                                                                        6/10 
  Erasing    : cronie-anacron-1.4.4-16.el6_8.2.i686                                                                                                                                               7/10 
  Erasing    : cronie-1.4.4-16.el6_8.2.i686                                                                                                                                                       8/10 
  Erasing    : 2:postfix-2.6.6-6.el6_7.1.i686                                                                                                                                                     9/10 
  Erasing    : mysql-libs-5.1.73-7.el6.i686                                                                                                                                                      10/10 
  Verifying  : redhat-lsb-core-4.0-7.el6.centos.i686                                                                                                                                              1/10 
  Verifying  : perl-DBD-MySQL-4.013-3.el6.i686                                                                                                                                                    2/10 
  Verifying  : mysql-server-5.1.73-7.el6.i686                                                                                                                                                     3/10 
  Verifying  : crontabs-1.10-33.el6.noarch                                                                                                                                                        4/10 
  Verifying  : sysstat-9.0.4-31.el6.i686                                                                                                                                                          5/10 
  Verifying  : cronie-anacron-1.4.4-16.el6_8.2.i686                                                                                                                                               6/10 
  Verifying  : cronie-1.4.4-16.el6_8.2.i686                                                                                                                                                       7/10 
  Verifying  : mysql-libs-5.1.73-7.el6.i686                                                                                                                                                       8/10 
  Verifying  : mysql-5.1.73-7.el6.i686                                                                                                                                                            9/10 
  Verifying  : 2:postfix-2.6.6-6.el6_7.1.i686                                                                                                                                                    10/10 

Removed:
  mysql.i686 0:5.1.73-7.el6                                     mysql-libs.i686 0:5.1.73-7.el6                                     mysql-server.i686 0:5.1.73-7.el6                                    

Dependency Removed:
  cronie.i686 0:1.4.4-16.el6_8.2              cronie-anacron.i686 0:1.4.4-16.el6_8.2     crontabs.noarch 0:1.10-33.el6     perl-DBD-MySQL.i686 0:4.013-3.el6     postfix.i686 2:2.6.6-6.el6_7.1    
  redhat-lsb-core.i686 0:4.0-7.el6.centos     sysstat.i686 0:9.0.4-31.el6               

Complete!

这样就卸载完成了,为了保险起见我们检查一下系统中是否还有 MySQL 相关内容没有删除干净

[root@coderknock ~]# yum list installed | grep mysql
[root@coderknock ~]#

上面的情况是没有未删除部分,如果有的话可通过下面的命令删除:

[root@coderknock ~]# yum remove mysql-libs

下载最新版本的 MySQL

#####查看系统配置信息选择对应 MySQL 包

[root@coderknock ~]# uname  -r 
3.10.104-1.el6.elrepo.i686

在浏览器打开 sohu提供的 MySQL 镜像(官网速度太慢) 然后根据自己系统配置选择对应的 rpm 包,右键复制文件链接,我的选择如下:

本文来自网络,不代表云浮站长网立场。转载请注明出处: https://www.0766zz.com/html/zhonghe/fwq/centos/20200901/8697.html
上一篇
下一篇

作者: dawei

【声明】:云浮站长网内容转载自互联网,其相关言论仅代表作者个人观点绝非权威,不代表本站立场。如您发现内容存在版权问题,请提交相关链接至邮箱:bqsm@foxmail.com,我们将及时予以处理。

为您推荐

返回顶部