MySQL8安装后管理三小版本升级

「爱情、让人受尽委屈。」 2024-03-24 18:02 31阅读 0赞

在安装部署MySQL8之后， 如果遇到重大bug或者需要新的特性，就需要升级小版本了，MySQL升级小版本比以前简单多了，在此演示一下。

本次演示由8.0.18升级到8.0.32

### 一 安装 MySQL 8.0.18 ###

#关闭selinux
    sed -i "s/SELINUX=enforcing/SELINUX=disabled/g" /etc/selinux/config ; 
    setenforce 0
    
    #解压安装包
    [root@localhost ~]# tar -xvf mysql-8.0.18-1.el7.x86_64.rpm-bundle.tar 
    mysql-community-libs-8.0.18-1.el7.x86_64.rpm
    mysql-community-devel-8.0.18-1.el7.x86_64.rpm
    mysql-community-embedded-compat-8.0.18-1.el7.x86_64.rpm
    mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm
    mysql-community-common-8.0.18-1.el7.x86_64.rpm
    mysql-community-server-8.0.18-1.el7.x86_64.rpm
    mysql-community-client-8.0.18-1.el7.x86_64.rpm
    
    #移除mariadb-libs
    [root@localhost ~]# yum -y remove mariadb-libs
    Loaded plugins: fastestmirror
    Resolving Dependencies
    --> Running transaction check
    ---> Package mariadb-libs.x86_64 1:5.5.65-1.el7 will be erased
    --> Processing Dependency: libmysqlclient.so.18()(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
    --> Processing Dependency: libmysqlclient.so.18(libmysqlclient_18)(64bit) for package: 2:postfix-2.10.1-9.el7.x86_64
    --> Running transaction check
    ---> Package postfix.x86_64 2:2.10.1-9.el7 will be erased
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ===================================================================================================================================================
     Package                             Arch                          Version                                  Repository                        Size
    ===================================================================================================================================================
    Removing:
     mariadb-libs                        x86_64                        1:5.5.65-1.el7                           @anaconda                        4.4 M
    Removing for dependencies:
     postfix                             x86_64                        2:2.10.1-9.el7                           @anaconda                         12 M
    
    Transaction Summary
    ===================================================================================================================================================
    Remove  1 Package (+1 Dependent package)
    
    Installed size: 17 M
    Downloading packages:
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
      Erasing    : 2:postfix-2.10.1-9.el7.x86_64                                                                                                   1/2 
      Erasing    : 1:mariadb-libs-5.5.65-1.el7.x86_64                                                                                              2/2 
      Verifying  : 1:mariadb-libs-5.5.65-1.el7.x86_64                                                                                              1/2 
      Verifying  : 2:postfix-2.10.1-9.el7.x86_64                                                                                                   2/2 
    
    Removed:
      mariadb-libs.x86_64 1:5.5.65-1.el7                                                                                                               
    
    Dependency Removed:
      postfix.x86_64 2:2.10.1-9.el7                                                                                                                    
    
    Complete!
      
    #安装
    [root@localhost ~]# yum -y localinstall mysql-community-{server,client,common,libs,devel,libs-compat}-8.0.18-1.el7.x86_64.rpm
    Loaded plugins: fastestmirror
    Examining mysql-community-server-8.0.18-1.el7.x86_64.rpm: mysql-community-server-8.0.18-1.el7.x86_64
    Marking mysql-community-server-8.0.18-1.el7.x86_64.rpm to be installed
    Examining mysql-community-client-8.0.18-1.el7.x86_64.rpm: mysql-community-client-8.0.18-1.el7.x86_64
    Marking mysql-community-client-8.0.18-1.el7.x86_64.rpm to be installed
    Examining mysql-community-common-8.0.18-1.el7.x86_64.rpm: mysql-community-common-8.0.18-1.el7.x86_64
    Marking mysql-community-common-8.0.18-1.el7.x86_64.rpm to be installed
    Examining mysql-community-libs-8.0.18-1.el7.x86_64.rpm: mysql-community-libs-8.0.18-1.el7.x86_64
    Marking mysql-community-libs-8.0.18-1.el7.x86_64.rpm to be installed
    Examining mysql-community-devel-8.0.18-1.el7.x86_64.rpm: mysql-community-devel-8.0.18-1.el7.x86_64
    Marking mysql-community-devel-8.0.18-1.el7.x86_64.rpm to be installed
    Examining mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm: mysql-community-libs-compat-8.0.18-1.el7.x86_64
    Marking mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm to be installed
    Resolving Dependencies
    --> Running transaction check
    ---> Package mysql-community-client.x86_64 0:8.0.18-1.el7 will be installed
    ---> Package mysql-community-common.x86_64 0:8.0.18-1.el7 will be installed
    ---> Package mysql-community-devel.x86_64 0:8.0.18-1.el7 will be installed
    --> Processing Dependency: pkgconfig(openssl) for package: mysql-community-devel-8.0.18-1.el7.x86_64
    Determining fastest mirrors
    centos_base                                                                                                                 | 3.6 kB  00:00:00     
    ---> Package mysql-community-libs.x86_64 0:8.0.18-1.el7 will be installed
    ---> Package mysql-community-libs-compat.x86_64 0:8.0.18-1.el7 will be installed
    ---> Package mysql-community-server.x86_64 0:8.0.18-1.el7 will be installed
    --> Processing Dependency: /usr/bin/perl for package: mysql-community-server-8.0.18-1.el7.x86_64
    --> Processing Dependency: net-tools for package: mysql-community-server-8.0.18-1.el7.x86_64
    --> Processing Dependency: perl(Getopt::Long) for package: mysql-community-server-8.0.18-1.el7.x86_64
    --> Processing Dependency: perl(strict) for package: mysql-community-server-8.0.18-1.el7.x86_64
    --> Running transaction check
    ---> Package net-tools.x86_64 0:2.0-0.25.20131004git.el7 will be installed
    ---> Package openssl-devel.x86_64 1:1.0.2k-19.el7 will be installed
    --> Processing Dependency: zlib-devel(x86-64) for package: 1:openssl-devel-1.0.2k-19.el7.x86_64
    --> Processing Dependency: krb5-devel(x86-64) for package: 1:openssl-devel-1.0.2k-19.el7.x86_64
    ---> Package perl.x86_64 4:5.16.3-297.el7 will be installed
    --> Processing Dependency: perl-libs = 4:5.16.3-297.el7 for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Socket) >= 1.3 for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Scalar::Util) >= 1.10 for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl-macros for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl-libs for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(threads::shared) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(threads) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(constant) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Time::Local) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Time::HiRes) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Storable) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Socket) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Scalar::Util) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Pod::Simple::XHTML) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Pod::Simple::Search) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Filter::Util::Call) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(File::Temp) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(File::Spec::Unix) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(File::Spec::Functions) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(File::Spec) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(File::Path) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Exporter) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Cwd) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: perl(Carp) for package: 4:perl-5.16.3-297.el7.x86_64
    --> Processing Dependency: libperl.so()(64bit) for package: 4:perl-5.16.3-297.el7.x86_64
    ---> Package perl-Getopt-Long.noarch 0:2.40-3.el7 will be installed
    --> Processing Dependency: perl(Pod::Usage) >= 1.14 for package: perl-Getopt-Long-2.40-3.el7.noarch
    --> Processing Dependency: perl(Text::ParseWords) for package: perl-Getopt-Long-2.40-3.el7.noarch
    --> Running transaction check
    ---> Package krb5-devel.x86_64 0:1.15.1-50.el7 will be installed
    --> Processing Dependency: libkadm5(x86-64) = 1.15.1-50.el7 for package: krb5-devel-1.15.1-50.el7.x86_64
    --> Processing Dependency: libverto-devel for package: krb5-devel-1.15.1-50.el7.x86_64
    --> Processing Dependency: libselinux-devel for package: krb5-devel-1.15.1-50.el7.x86_64
    --> Processing Dependency: libcom_err-devel for package: krb5-devel-1.15.1-50.el7.x86_64
    --> Processing Dependency: keyutils-libs-devel for package: krb5-devel-1.15.1-50.el7.x86_64
    ---> Package perl-Carp.noarch 0:1.26-244.el7 will be installed
    ---> Package perl-Exporter.noarch 0:5.68-3.el7 will be installed
    ---> Package perl-File-Path.noarch 0:2.09-2.el7 will be installed
    ---> Package perl-File-Temp.noarch 0:0.23.01-3.el7 will be installed
    ---> Package perl-Filter.x86_64 0:1.49-3.el7 will be installed
    ---> Package perl-PathTools.x86_64 0:3.40-5.el7 will be installed
    ---> Package perl-Pod-Simple.noarch 1:3.28-4.el7 will be installed
    --> Processing Dependency: perl(Pod::Escapes) >= 1.04 for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
    --> Processing Dependency: perl(Encode) for package: 1:perl-Pod-Simple-3.28-4.el7.noarch
    ---> Package perl-Pod-Usage.noarch 0:1.63-3.el7 will be installed
    --> Processing Dependency: perl(Pod::Text) >= 3.15 for package: perl-Pod-Usage-1.63-3.el7.noarch
    --> Processing Dependency: perl-Pod-Perldoc for package: perl-Pod-Usage-1.63-3.el7.noarch
    ---> Package perl-Scalar-List-Utils.x86_64 0:1.27-248.el7 will be installed
    ---> Package perl-Socket.x86_64 0:2.010-5.el7 will be installed
    ---> Package perl-Storable.x86_64 0:2.45-3.el7 will be installed
    ---> Package perl-Text-ParseWords.noarch 0:3.29-4.el7 will be installed
    ---> Package perl-Time-HiRes.x86_64 4:1.9725-3.el7 will be installed
    ---> Package perl-Time-Local.noarch 0:1.2300-2.el7 will be installed
    ---> Package perl-constant.noarch 0:1.27-2.el7 will be installed
    ---> Package perl-libs.x86_64 4:5.16.3-297.el7 will be installed
    ---> Package perl-macros.x86_64 4:5.16.3-297.el7 will be installed
    ---> Package perl-threads.x86_64 0:1.87-4.el7 will be installed
    ---> Package perl-threads-shared.x86_64 0:1.43-6.el7 will be installed
    ---> Package zlib-devel.x86_64 0:1.2.7-18.el7 will be installed
    --> Running transaction check
    ---> Package keyutils-libs-devel.x86_64 0:1.5.8-3.el7 will be installed
    ---> Package libcom_err-devel.x86_64 0:1.42.9-19.el7 will be installed
    ---> Package libkadm5.x86_64 0:1.15.1-50.el7 will be installed
    ---> Package libselinux-devel.x86_64 0:2.5-15.el7 will be installed
    --> Processing Dependency: libsepol-devel(x86-64) >= 2.5-10 for package: libselinux-devel-2.5-15.el7.x86_64
    --> Processing Dependency: pkgconfig(libsepol) for package: libselinux-devel-2.5-15.el7.x86_64
    --> Processing Dependency: pkgconfig(libpcre) for package: libselinux-devel-2.5-15.el7.x86_64
    ---> Package libverto-devel.x86_64 0:0.2.5-4.el7 will be installed
    ---> Package perl-Encode.x86_64 0:2.51-7.el7 will be installed
    ---> Package perl-Pod-Escapes.noarch 1:1.04-297.el7 will be installed
    ---> Package perl-Pod-Perldoc.noarch 0:3.20-4.el7 will be installed
    --> Processing Dependency: perl(parent) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
    --> Processing Dependency: perl(HTTP::Tiny) for package: perl-Pod-Perldoc-3.20-4.el7.noarch
    ---> Package perl-podlators.noarch 0:2.5.1-3.el7 will be installed
    --> Running transaction check
    ---> Package libsepol-devel.x86_64 0:2.5-10.el7 will be installed
    ---> Package pcre-devel.x86_64 0:8.32-17.el7 will be installed
    ---> Package perl-HTTP-Tiny.noarch 0:0.033-3.el7 will be installed
    ---> Package perl-parent.noarch 1:0.225-244.el7 will be installed
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ===================================================================================================================================================
     Package                            Arch          Version                            Repository                                               Size
    ===================================================================================================================================================
    Installing:
     mysql-community-client             x86_64        8.0.18-1.el7                       /mysql-community-client-8.0.18-1.el7.x86_64             177 M
     mysql-community-common             x86_64        8.0.18-1.el7                       /mysql-community-common-8.0.18-1.el7.x86_64             8.4 M
     mysql-community-devel              x86_64        8.0.18-1.el7                       /mysql-community-devel-8.0.18-1.el7.x86_64               44 M
     mysql-community-libs               x86_64        8.0.18-1.el7                       /mysql-community-libs-8.0.18-1.el7.x86_64                17 M
     mysql-community-libs-compat        x86_64        8.0.18-1.el7                       /mysql-community-libs-compat-8.0.18-1.el7.x86_64        6.3 M
     mysql-community-server             x86_64        8.0.18-1.el7                       /mysql-community-server-8.0.18-1.el7.x86_64             1.9 G
    Installing for dependencies:
     keyutils-libs-devel                x86_64        1.5.8-3.el7                        centos_base                                              37 k
     krb5-devel                         x86_64        1.15.1-50.el7                      centos_base                                             273 k
     libcom_err-devel                   x86_64        1.42.9-19.el7                      centos_base                                              32 k
     libkadm5                           x86_64        1.15.1-50.el7                      centos_base                                             179 k
     libselinux-devel                   x86_64        2.5-15.el7                         centos_base                                             187 k
     libsepol-devel                     x86_64        2.5-10.el7                         centos_base                                              77 k
     libverto-devel                     x86_64        0.2.5-4.el7                        centos_base                                              12 k
     net-tools                          x86_64        2.0-0.25.20131004git.el7           centos_base                                             306 k
     openssl-devel                      x86_64        1:1.0.2k-19.el7                    centos_base                                             1.5 M
     pcre-devel                         x86_64        8.32-17.el7                        centos_base                                             480 k
     perl                               x86_64        4:5.16.3-297.el7                   centos_base                                             8.0 M
     perl-Carp                          noarch        1.26-244.el7                       centos_base                                              19 k
     perl-Encode                        x86_64        2.51-7.el7                         centos_base                                             1.5 M
     perl-Exporter                      noarch        5.68-3.el7                         centos_base                                              28 k
     perl-File-Path                     noarch        2.09-2.el7                         centos_base                                              26 k
     perl-File-Temp                     noarch        0.23.01-3.el7                      centos_base                                              56 k
     perl-Filter                        x86_64        1.49-3.el7                         centos_base                                              76 k
     perl-Getopt-Long                   noarch        2.40-3.el7                         centos_base                                              56 k
     perl-HTTP-Tiny                     noarch        0.033-3.el7                        centos_base                                              38 k
     perl-PathTools                     x86_64        3.40-5.el7                         centos_base                                              82 k
     perl-Pod-Escapes                   noarch        1:1.04-297.el7                     centos_base                                              52 k
     perl-Pod-Perldoc                   noarch        3.20-4.el7                         centos_base                                              87 k
     perl-Pod-Simple                    noarch        1:3.28-4.el7                       centos_base                                             216 k
     perl-Pod-Usage                     noarch        1.63-3.el7                         centos_base                                              27 k
     perl-Scalar-List-Utils             x86_64        1.27-248.el7                       centos_base                                              36 k
     perl-Socket                        x86_64        2.010-5.el7                        centos_base                                              49 k
     perl-Storable                      x86_64        2.45-3.el7                         centos_base                                              77 k
     perl-Text-ParseWords               noarch        3.29-4.el7                         centos_base                                              14 k
     perl-Time-HiRes                    x86_64        4:1.9725-3.el7                     centos_base                                              45 k
     perl-Time-Local                    noarch        1.2300-2.el7                       centos_base                                              24 k
     perl-constant                      noarch        1.27-2.el7                         centos_base                                              19 k
     perl-libs                          x86_64        4:5.16.3-297.el7                   centos_base                                             689 k
     perl-macros                        x86_64        4:5.16.3-297.el7                   centos_base                                              44 k
     perl-parent                        noarch        1:0.225-244.el7                    centos_base                                              12 k
     perl-podlators                     noarch        2.5.1-3.el7                        centos_base                                             112 k
     perl-threads                       x86_64        1.87-4.el7                         centos_base                                              49 k
     perl-threads-shared                x86_64        1.43-6.el7                         centos_base                                              39 k
     zlib-devel                         x86_64        1.2.7-18.el7                       centos_base                                              50 k
    
    Transaction Summary
    ===================================================================================================================================================
    Install  6 Packages (+38 Dependent packages)
    
    Total size: 2.2 G
    Total download size: 14 M
    Installed size: 2.2 G
    Downloading packages:
    ---------------------------------------------------------------------------------------------------------------------------------------------------
    Total                                                                                                               41 MB/s |  14 MB  00:00:00     
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
      Installing : mysql-community-common-8.0.18-1.el7.x86_64                                                                                     1/44 
      Installing : mysql-community-libs-8.0.18-1.el7.x86_64                                                                                       2/44 
      Installing : mysql-community-client-8.0.18-1.el7.x86_64                                                                                     3/44 
      Installing : 1:perl-parent-0.225-244.el7.noarch                                                                                             4/44 
      Installing : perl-HTTP-Tiny-0.033-3.el7.noarch                                                                                              5/44 
      Installing : perl-podlators-2.5.1-3.el7.noarch                                                                                              6/44 
      Installing : perl-Pod-Perldoc-3.20-4.el7.noarch                                                                                             7/44 
      Installing : 1:perl-Pod-Escapes-1.04-297.el7.noarch                                                                                         8/44 
      Installing : perl-Encode-2.51-7.el7.x86_64                                                                                                  9/44 
      Installing : perl-Text-ParseWords-3.29-4.el7.noarch                                                                                        10/44 
      Installing : perl-Pod-Usage-1.63-3.el7.noarch                                                                                              11/44 
      Installing : 4:perl-libs-5.16.3-297.el7.x86_64                                                                                             12/44 
      Installing : perl-Storable-2.45-3.el7.x86_64                                                                                               13/44 
      Installing : perl-Exporter-5.68-3.el7.noarch                                                                                               14/44 
      Installing : perl-constant-1.27-2.el7.noarch                                                                                               15/44 
      Installing : perl-Socket-2.010-5.el7.x86_64                                                                                                16/44 
      Installing : perl-Time-Local-1.2300-2.el7.noarch                                                                                           17/44 
      Installing : perl-Carp-1.26-244.el7.noarch                                                                                                 18/44 
      Installing : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                                                                         19/44 
      Installing : 1:perl-Pod-Simple-3.28-4.el7.noarch                                                                                           20/44 
      Installing : perl-PathTools-3.40-5.el7.x86_64                                                                                              21/44 
      Installing : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                                                                    22/44 
      Installing : perl-threads-shared-1.43-6.el7.x86_64                                                                                         23/44 
      Installing : perl-threads-1.87-4.el7.x86_64                                                                                                24/44 
      Installing : perl-Filter-1.49-3.el7.x86_64                                                                                                 25/44 
      Installing : perl-File-Temp-0.23.01-3.el7.noarch                                                                                           26/44 
      Installing : perl-File-Path-2.09-2.el7.noarch                                                                                              27/44 
      Installing : 4:perl-macros-5.16.3-297.el7.x86_64                                                                                           28/44 
      Installing : perl-Getopt-Long-2.40-3.el7.noarch                                                                                            29/44 
      Installing : 4:perl-5.16.3-297.el7.x86_64                                                                                                  30/44 
      Installing : libcom_err-devel-1.42.9-19.el7.x86_64                                                                                         31/44 
      Installing : pcre-devel-8.32-17.el7.x86_64                                                                                                 32/44 
      Installing : libsepol-devel-2.5-10.el7.x86_64                                                                                              33/44 
      Installing : libselinux-devel-2.5-15.el7.x86_64                                                                                            34/44 
      Installing : net-tools-2.0-0.25.20131004git.el7.x86_64                                                                                     35/44 
      Installing : zlib-devel-1.2.7-18.el7.x86_64                                                                                                36/44 
      Installing : libverto-devel-0.2.5-4.el7.x86_64                                                                                             37/44 
      Installing : libkadm5-1.15.1-50.el7.x86_64                                                                                                 38/44 
      Installing : keyutils-libs-devel-1.5.8-3.el7.x86_64                                                                                        39/44 
      Installing : krb5-devel-1.15.1-50.el7.x86_64                                                                                               40/44 
      Installing : 1:openssl-devel-1.0.2k-19.el7.x86_64                                                                                          41/44 
      Installing : mysql-community-devel-8.0.18-1.el7.x86_64                                                                                     42/44 
      Installing : mysql-community-server-8.0.18-1.el7.x86_64                                                                                    43/44 
      Installing : mysql-community-libs-compat-8.0.18-1.el7.x86_64                                                                               44/44 
      Verifying  : perl-HTTP-Tiny-0.033-3.el7.noarch                                                                                              1/44 
      Verifying  : libselinux-devel-2.5-15.el7.x86_64                                                                                             2/44 
      Verifying  : keyutils-libs-devel-1.5.8-3.el7.x86_64                                                                                         3/44 
      Verifying  : 1:perl-Pod-Escapes-1.04-297.el7.noarch                                                                                         4/44 
      Verifying  : perl-threads-shared-1.43-6.el7.x86_64                                                                                          5/44 
      Verifying  : perl-Storable-2.45-3.el7.x86_64                                                                                                6/44 
      Verifying  : 4:perl-libs-5.16.3-297.el7.x86_64                                                                                              7/44 
      Verifying  : perl-Exporter-5.68-3.el7.noarch                                                                                                8/44 
      Verifying  : perl-constant-1.27-2.el7.noarch                                                                                                9/44 
      Verifying  : perl-PathTools-3.40-5.el7.x86_64                                                                                              10/44 
      Verifying  : perl-Socket-2.010-5.el7.x86_64                                                                                                11/44 
      Verifying  : libkadm5-1.15.1-50.el7.x86_64                                                                                                 12/44 
      Verifying  : 1:perl-parent-0.225-244.el7.noarch                                                                                            13/44 
      Verifying  : libverto-devel-0.2.5-4.el7.x86_64                                                                                             14/44 
      Verifying  : zlib-devel-1.2.7-18.el7.x86_64                                                                                                15/44 
      Verifying  : mysql-community-server-8.0.18-1.el7.x86_64                                                                                    16/44 
      Verifying  : perl-File-Temp-0.23.01-3.el7.noarch                                                                                           17/44 
      Verifying  : net-tools-2.0-0.25.20131004git.el7.x86_64                                                                                     18/44 
      Verifying  : 1:perl-Pod-Simple-3.28-4.el7.noarch                                                                                           19/44 
      Verifying  : mysql-community-libs-8.0.18-1.el7.x86_64                                                                                      20/44 
      Verifying  : perl-Time-Local-1.2300-2.el7.noarch                                                                                           21/44 
      Verifying  : perl-Encode-2.51-7.el7.x86_64                                                                                                 22/44 
      Verifying  : perl-Carp-1.26-244.el7.noarch                                                                                                 23/44 
      Verifying  : 4:perl-Time-HiRes-1.9725-3.el7.x86_64                                                                                         24/44 
      Verifying  : 1:openssl-devel-1.0.2k-19.el7.x86_64                                                                                          25/44 
      Verifying  : perl-Scalar-List-Utils-1.27-248.el7.x86_64                                                                                    26/44 
      Verifying  : mysql-community-libs-compat-8.0.18-1.el7.x86_64                                                                               27/44 
      Verifying  : libsepol-devel-2.5-10.el7.x86_64                                                                                              28/44 
      Verifying  : perl-Pod-Usage-1.63-3.el7.noarch                                                                                              29/44 
      Verifying  : mysql-community-client-8.0.18-1.el7.x86_64                                                                                    30/44 
      Verifying  : mysql-community-devel-8.0.18-1.el7.x86_64                                                                                     31/44 
      Verifying  : perl-Pod-Perldoc-3.20-4.el7.noarch                                                                                            32/44 
      Verifying  : perl-podlators-2.5.1-3.el7.noarch                                                                                             33/44 
      Verifying  : pcre-devel-8.32-17.el7.x86_64                                                                                                 34/44 
      Verifying  : krb5-devel-1.15.1-50.el7.x86_64                                                                                               35/44 
      Verifying  : mysql-community-common-8.0.18-1.el7.x86_64                                                                                    36/44 
      Verifying  : perl-threads-1.87-4.el7.x86_64                                                                                                37/44 
      Verifying  : perl-Filter-1.49-3.el7.x86_64                                                                                                 38/44 
      Verifying  : perl-Getopt-Long-2.40-3.el7.noarch                                                                                            39/44 
      Verifying  : perl-Text-ParseWords-3.29-4.el7.noarch                                                                                        40/44 
      Verifying  : libcom_err-devel-1.42.9-19.el7.x86_64                                                                                         41/44 
      Verifying  : perl-File-Path-2.09-2.el7.noarch                                                                                              42/44 
      Verifying  : 4:perl-5.16.3-297.el7.x86_64                                                                                                  43/44 
      Verifying  : 4:perl-macros-5.16.3-297.el7.x86_64                                                                                           44/44 
    
    Installed:
      mysql-community-client.x86_64 0:8.0.18-1.el7   mysql-community-common.x86_64 0:8.0.18-1.el7        mysql-community-devel.x86_64 0:8.0.18-1.el7   
      mysql-community-libs.x86_64 0:8.0.18-1.el7     mysql-community-libs-compat.x86_64 0:8.0.18-1.el7   mysql-community-server.x86_64 0:8.0.18-1.el7  
    
    Dependency Installed:
      keyutils-libs-devel.x86_64 0:1.5.8-3.el7          krb5-devel.x86_64 0:1.15.1-50.el7                libcom_err-devel.x86_64 0:1.42.9-19.el7     
      libkadm5.x86_64 0:1.15.1-50.el7                   libselinux-devel.x86_64 0:2.5-15.el7             libsepol-devel.x86_64 0:2.5-10.el7          
      libverto-devel.x86_64 0:0.2.5-4.el7               net-tools.x86_64 0:2.0-0.25.20131004git.el7      openssl-devel.x86_64 1:1.0.2k-19.el7        
      pcre-devel.x86_64 0:8.32-17.el7                   perl.x86_64 4:5.16.3-297.el7                     perl-Carp.noarch 0:1.26-244.el7             
      perl-Encode.x86_64 0:2.51-7.el7                   perl-Exporter.noarch 0:5.68-3.el7                perl-File-Path.noarch 0:2.09-2.el7          
      perl-File-Temp.noarch 0:0.23.01-3.el7             perl-Filter.x86_64 0:1.49-3.el7                  perl-Getopt-Long.noarch 0:2.40-3.el7        
      perl-HTTP-Tiny.noarch 0:0.033-3.el7               perl-PathTools.x86_64 0:3.40-5.el7               perl-Pod-Escapes.noarch 1:1.04-297.el7      
      perl-Pod-Perldoc.noarch 0:3.20-4.el7              perl-Pod-Simple.noarch 1:3.28-4.el7              perl-Pod-Usage.noarch 0:1.63-3.el7          
      perl-Scalar-List-Utils.x86_64 0:1.27-248.el7      perl-Socket.x86_64 0:2.010-5.el7                 perl-Storable.x86_64 0:2.45-3.el7           
      perl-Text-ParseWords.noarch 0:3.29-4.el7          perl-Time-HiRes.x86_64 4:1.9725-3.el7            perl-Time-Local.noarch 0:1.2300-2.el7       
      perl-constant.noarch 0:1.27-2.el7                 perl-libs.x86_64 4:5.16.3-297.el7                perl-macros.x86_64 4:5.16.3-297.el7         
      perl-parent.noarch 1:0.225-244.el7                perl-podlators.noarch 0:2.5.1-3.el7              perl-threads.x86_64 0:1.87-4.el7            
      perl-threads-shared.x86_64 0:1.43-6.el7           zlib-devel.x86_64 0:1.2.7-18.el7                
    
    Complete!
      
    #启动实例
    [root@localhost ~]# systemctl --now enable mysqld
    
    #默认的管理员密码在日志中， 此处读取日志中管理员密码登录并修改管理员密码
    [root@localhost ~]# mysql -u root -p`grep 'temporary password' /var/log/mysqld.log|tail -1 |awk '{print $NF}'`
    mysql: [Warning] Using a password on the command line interface can be insecure.
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 8
    Server version: 8.0.18
    
    Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> set password='********';
    Query OK, 0 rows affected (0.00 sec)
    
    mysql> use mysql;
    Reading table information for completion of table and column names
    You can turn off this feature to get a quicker startup with -A
    
    Database changed
    mysql> create table t1(c1 int);
    Query OK, 0 rows affected (0.01 sec)
    
    mysql> insert into t1 values(1),(2);
    Query OK, 2 rows affected (0.00 sec)
    Records: 2  Duplicates: 0  Warnings: 0
    
    mysql> commit;
    Query OK, 0 rows affected (0.00 sec)

### 二 查看当前版本 ###

版本为 8.0.18

### 三 升级到8.0.25 ###

#关闭实例
    [root@localhost ~]# systemctl stop mysqld
    #备份一下
    [root@localhost ~]# cp -a /var/lib/mysql /var/lib/mysql.$(date +%Y%m%d%H%M%S)
    
    #解压安装包
    [root@localhost ~]# tar -xvf mysql-8.0.32-1.el7.x86_64.rpm-bundle.tar 
    mysql-community-client-8.0.32-1.el7.x86_64.rpm
    mysql-community-client-plugins-8.0.32-1.el7.x86_64.rpm
    mysql-community-common-8.0.32-1.el7.x86_64.rpm
    mysql-community-devel-8.0.32-1.el7.x86_64.rpm
    mysql-community-embedded-compat-8.0.32-1.el7.x86_64.rpm
    mysql-community-icu-data-files-8.0.32-1.el7.x86_64.rpm
    mysql-community-libs-8.0.32-1.el7.x86_64.rpm
    mysql-community-libs-compat-8.0.32-1.el7.x86_64.rpm
    mysql-community-server-8.0.32-1.el7.x86_64.rpm
    
    #升级 先卸载冲突的旧版本， 不冲突的可以直接升级
    [root@localhost ~]# yum -y remove mysql-community-client-8.0.18
    Loaded plugins: fastestmirror
    Resolving Dependencies
    --> Running transaction check
    ---> Package mysql-community-client.x86_64 0:8.0.18-1.el7 will be erased
    --> Processing Dependency: mysql-community-client(x86-64) >= 8.0.11 for package: mysql-community-server-8.0.18-1.el7.x86_64
    --> Running transaction check
    ---> Package mysql-community-server.x86_64 0:8.0.18-1.el7 will be erased
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ===================================================================================================================================================
     Package                             Arch                Version                   Repository                                                 Size
    ===================================================================================================================================================
    Removing:
     mysql-community-client              x86_64              8.0.18-1.el7              @/mysql-community-client-8.0.18-1.el7.x86_64              177 M
    Removing for dependencies:
     mysql-community-server              x86_64              8.0.18-1.el7              @/mysql-community-server-8.0.18-1.el7.x86_64              1.9 G
    
    Transaction Summary
    ===================================================================================================================================================
    Remove  1 Package (+1 Dependent package)
    
    Installed size: 2.1 G
    Downloading packages:
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
      Erasing    : mysql-community-server-8.0.18-1.el7.x86_64                                                                                      1/2 
      Erasing    : mysql-community-client-8.0.18-1.el7.x86_64                                                                                      2/2 
      Verifying  : mysql-community-client-8.0.18-1.el7.x86_64                                                                                      1/2 
      Verifying  : mysql-community-server-8.0.18-1.el7.x86_64                                                                                      2/2 
    
    Removed:
      mysql-community-client.x86_64 0:8.0.18-1.el7                                                                                                     
    
    Dependency Removed:
      mysql-community-server.x86_64 0:8.0.18-1.el7                                                                                                     
    
    Complete!
    [root@localhost ~]# yum -y install mysql-community-{icu-data-files,client-plugins}-8.0.32-1.el7.x86_64.rpm
    Loaded plugins: fastestmirror
    Examining mysql-community-icu-data-files-8.0.32-1.el7.x86_64.rpm: mysql-community-icu-data-files-8.0.32-1.el7.x86_64
    Marking mysql-community-icu-data-files-8.0.32-1.el7.x86_64.rpm to be installed
    Examining mysql-community-client-plugins-8.0.32-1.el7.x86_64.rpm: mysql-community-client-plugins-8.0.32-1.el7.x86_64
    Marking mysql-community-client-plugins-8.0.32-1.el7.x86_64.rpm to be installed
    Resolving Dependencies
    --> Running transaction check
    ---> Package mysql-community-client-plugins.x86_64 0:8.0.32-1.el7 will be installed
    ---> Package mysql-community-icu-data-files.x86_64 0:8.0.32-1.el7 will be installed
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ===================================================================================================================================================
     Package                                 Arch            Version                Repository                                                    Size
    ===================================================================================================================================================
    Installing:
     mysql-community-client-plugins          x86_64          8.0.32-1.el7           /mysql-community-client-plugins-8.0.32-1.el7.x86_64           14 M
     mysql-community-icu-data-files          x86_64          8.0.32-1.el7           /mysql-community-icu-data-files-8.0.32-1.el7.x86_64          3.5 M
    
    Transaction Summary
    ===================================================================================================================================================
    Install  2 Packages
    
    Total size: 17 M
    Installed size: 17 M
    Downloading packages:
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
      Installing : mysql-community-client-plugins-8.0.32-1.el7.x86_64                                                                              1/2 
      Installing : mysql-community-icu-data-files-8.0.32-1.el7.x86_64                                                                              2/2 
      Verifying  : mysql-community-icu-data-files-8.0.32-1.el7.x86_64                                                                              1/2 
      Verifying  : mysql-community-client-plugins-8.0.32-1.el7.x86_64                                                                              2/2 
    
    Installed:
      mysql-community-client-plugins.x86_64 0:8.0.32-1.el7                     mysql-community-icu-data-files.x86_64 0:8.0.32-1.el7                    
    
    Complete!
    [root@localhost ~]# yum -y upgrade mysql-community-{server,client,common,libs}-8.0.32-1.el7.x86_64.rpm
    Loaded plugins: fastestmirror
    Examining mysql-community-server-8.0.32-1.el7.x86_64.rpm: mysql-community-server-8.0.32-1.el7.x86_64
    Package mysql-community-server not installed, cannot update it. Run yum install to install it instead.
    Examining mysql-community-client-8.0.32-1.el7.x86_64.rpm: mysql-community-client-8.0.32-1.el7.x86_64
    Package mysql-community-client not installed, cannot update it. Run yum install to install it instead.
    Examining mysql-community-common-8.0.32-1.el7.x86_64.rpm: mysql-community-common-8.0.32-1.el7.x86_64
    Marking mysql-community-common-8.0.32-1.el7.x86_64.rpm as an update to mysql-community-common-8.0.18-1.el7.x86_64
    Examining mysql-community-libs-8.0.32-1.el7.x86_64.rpm: mysql-community-libs-8.0.32-1.el7.x86_64
    Marking mysql-community-libs-8.0.32-1.el7.x86_64.rpm as an update to mysql-community-libs-8.0.18-1.el7.x86_64
    Resolving Dependencies
    --> Running transaction check
    ---> Package mysql-community-common.x86_64 0:8.0.18-1.el7 will be updated
    ---> Package mysql-community-common.x86_64 0:8.0.32-1.el7 will be an update
    ---> Package mysql-community-libs.x86_64 0:8.0.18-1.el7 will be updated
    ---> Package mysql-community-libs.x86_64 0:8.0.32-1.el7 will be an update
    --> Finished Dependency Resolution
    
    Dependencies Resolved
    
    ===================================================================================================================================================
     Package                             Arch                Version                    Repository                                                Size
    ===================================================================================================================================================
    Updating:
     mysql-community-common              x86_64              8.0.32-1.el7               /mysql-community-common-8.0.32-1.el7.x86_64               10 M
     mysql-community-libs                x86_64              8.0.32-1.el7               /mysql-community-libs-8.0.32-1.el7.x86_64                7.6 M
    
    Transaction Summary
    ===================================================================================================================================================
    Upgrade  2 Packages
    
    Total size: 18 M
    Downloading packages:
    Running transaction check
    Running transaction test
    Transaction test succeeded
    Running transaction
      Updating   : mysql-community-common-8.0.32-1.el7.x86_64                                                                                      1/4 
      Updating   : mysql-community-libs-8.0.32-1.el7.x86_64                                                                                        2/4 
      Cleanup    : mysql-community-libs-8.0.18-1.el7.x86_64                                                                                        3/4 
      Cleanup    : mysql-community-common-8.0.18-1.el7.x86_64                                                                                      4/4 
      Verifying  : mysql-community-common-8.0.32-1.el7.x86_64                                                                                      1/4 
      Verifying  : mysql-community-libs-8.0.32-1.el7.x86_64                                                                                        2/4 
      Verifying  : mysql-community-common-8.0.18-1.el7.x86_64                                                                                      3/4 
      Verifying  : mysql-community-libs-8.0.18-1.el7.x86_64                                                                                        4/4 
    
    Updated:
      mysql-community-common.x86_64 0:8.0.32-1.el7                              mysql-community-libs.x86_64 0:8.0.32-1.el7                             
    
    Complete!

### 查看升级后版本 ###

[root@localhost ~]# mysql -u root -pRoot_1qaz -e "select @@version"
    mysql: [Warning] Using a password on the command line interface can be insecure.
    +-----------+
    | @@version |
    +-----------+
    | 8.0.32    |
    +-----------+
    [root@localhost ~]# mysql -u root -pRoot_1qaz -e "select * from mysql.t1"
    mysql: [Warning] Using a password on the command line interface can be insecure.
    +------+
    | c1   |
    +------+
    |    1 |
    |    2 |
    +------+

### 查看升级日志 ###

[root@localhost ~]# grep upgrade /var/log/mysqld.log
    2023-04-10T10:40:42.340183Z 1 [System] [MY-013413] [Server] Data dictionary upgrade from version '80017' to '80023' completed.
    2023-04-10T10:40:43.326728Z 4 [System] [MY-013381] [Server] Server upgrade from '80018' to '80032' started.
    2023-04-10T10:40:45.517257Z 4 [System] [MY-013381] [Server] Server upgrade from '80018' to '80032' completed.

升级成功了， 以前相邻版本升级直接使用 yum upgrade 就可以了， 这次可能是版本间隔比较大，新旧版本冲突了，需要先卸载就版本再安装新版本(不冲突的可以不卸载，直接升级）