mysql5.6升级到5.7

桃扇骨 2022-07-10 14:29 162阅读 0赞

1. 首先通过 vim /etc/yum.repos.d/mysql-community.repo

![Image 1][]\[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  
\[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  
  
  
\[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

yum源大致配置

引入5.7的安装包yum库 将enabled改为1 表示使用

2. yum install mysql-server

![Image 1][]

接着会出现安装5.7更新的提示，输入y

最终安装完成之后可以重启mysqld 即升级完成

mysql\_update -uroot -p

清理索引query

service mysqld restart 完成

注意:这样升级数据会丢失!

[Image 1]: