[mysql]-mysql升级版本包含源码和yum安装2种方式

╰+攻爆jí腚メ 2022-12-24 07:56 170阅读 0赞

##### 导语：近期做三级等保测评，需要升级mysql版本，修复高危漏洞。因此记录一下yum安装和源码包安装2种方式升级版本的办法。 #####

### yum升级 ###

cd /usr/local/src
    wget https://repo.mysql.com//mysql57-community-release-el7-11.noarch.rpm
    rpm -ivh mysql57-community-release-el7-11.noarch.rpm
    
    cat >/etc/yum.repos.d/mysql-community.repo <<EOF [mysql-connectors-community] name=MySQL Connectors Community baseurl=http://repo.mysql.com/yum/mysql-connectors-community/el/7/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql-tools-community] name=MySQL Tools Community baseurl=http://repo.mysql.com/yum/mysql-tools-community/el/7/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql # Enable to use MySQL 5.5 [mysql55-community] name=MySQL 5.5 Community Server baseurl=http://repo.mysql.com/yum/mysql-5.5-community/el/7/$basearch/ enabled=0 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql # Enable to use MySQL 5.6 [mysql56-community] name=MySQL 5.6 Community Server baseurl=http://repo.mysql.com/yum/mysql-5.6-community/el/7/$basearch/ enabled=0 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql57-community] name=MySQL 5.7 Community Server baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/ enabled=1 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql80-community] name=MySQL 8.0 Community Server baseurl=http://repo.mysql.com/yum/mysql-8.0-community/el/7/$basearch/ enabled=0 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql-tools-preview] name=MySQL Tools Preview baseurl=http://repo.mysql.com/yum/mysql-tools-preview/el/7/$basearch/ enabled=0 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql-cluster-7.5-community] name=MySQL Cluster 7.5 Community baseurl=http://repo.mysql.com/yum/mysql-cluster-7.5-community/el/7/$basearch/ enabled=0 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql [mysql-cluster-7.6-community] name=MySQL Cluster 7.6 Community baseurl=http://repo.mysql.com/yum/mysql-cluster-7.6-community/el/7/$basearch/ enabled=0 gpgcheck=1 gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql EOF
    
    # 查看mysql版本激活状况
    yum repolist all|grep mysql

![93526be1ad73b5e9b2cde9cf6c0169d1.png][]

# 升级
    yum update mysql-server

### 源码包安装 ###

# 解决后面报错 CMake Error at cmake/boost.cmake:88 (MESSAGE)
    mkdir /usr/local/boost
    cd /usr/local/boost
    wget http://sourceforge.net/projects/boost/files/boost/1.59.0/boost_1_59_0.tar.gz/download -O boost_1_59_0.tar.gz
    tar zxvf boost_1_59_0.tar.gz
    
    cd /usr/local/src
    wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.31.tar.gz
    tar zxvf  mysql-5.7.31.tar.gz
    yum -y install cmake
    yum install -y git
    yum install -y gcc
    yum install -y gcc-c++
    yum -y install openssl-devel
    
    
    cd mysql-5.7.31
    
    cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_EXTRA_CHARSETS=all -DSYSCONFDIR=/etc/ -DWITH_BOOST=/usr/local/boost

> 如果报错CMake Error: The source directory “xxxx” does not appear to contain CMakeLists.txt. 说明下错包了 一定要下source code

![c3bd4be11be2540019355e72149dd52c.png][]

cmake成功如下所示 如果提示error或者什么log的 基本都是有步骤出错了

![7bb96da3874e6572553afb4fd474150e.png][]

编译安装

make && make install

![99b0460bad11b3383fdb2bddcdf229bd.png][]

替换旧版本 重启数据库

yes|cp /usr/local/mysql/support-files/mysql.server /etc/init.d/
    # 防止内部结构差异
    /usr/local/mysql/bin/mysql_upgrade -uroot -pHangzhou@123 --skip-version-check
    service mysqld restart

升级前的旧版本

![ecc42b83db32cc032f84da5597fd1a05.png][]

升级完成

![ea318c2750aa162b6b45f824241dcc0a.png][]

升级后

![32d74e263d1aecbc7bcbeb94786ab655.png][]

数据库 需要重启服务生效

![b3021781e9cdd54400c97036b5f2cb9f.png][]

[93526be1ad73b5e9b2cde9cf6c0169d1.png]: /images/20221120/850dd48b6cdb4db8a3af3a5019095b34.png
[c3bd4be11be2540019355e72149dd52c.png]: /images/20221120/f83040a50eb4455dbcc5769b0a3872b0.png
[7bb96da3874e6572553afb4fd474150e.png]: https://img-blog.csdnimg.cn/img_convert/7bb96da3874e6572553afb4fd474150e.png
[99b0460bad11b3383fdb2bddcdf229bd.png]: https://img-blog.csdnimg.cn/img_convert/99b0460bad11b3383fdb2bddcdf229bd.png
[ecc42b83db32cc032f84da5597fd1a05.png]: https://img-blog.csdnimg.cn/img_convert/ecc42b83db32cc032f84da5597fd1a05.png
[ea318c2750aa162b6b45f824241dcc0a.png]: https://img-blog.csdnimg.cn/img_convert/ea318c2750aa162b6b45f824241dcc0a.png
[32d74e263d1aecbc7bcbeb94786ab655.png]: https://img-blog.csdnimg.cn/img_convert/32d74e263d1aecbc7bcbeb94786ab655.png
[b3021781e9cdd54400c97036b5f2cb9f.png]: https://img-blog.csdnimg.cn/img_convert/b3021781e9cdd54400c97036b5f2cb9f.png