阶段1:
rpm -qa | grep mysql
wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.24-1.el6.x86_64.rpm-bundle.tar
wget https://cdn.mysql.com/archives/mysql-5.7/mysql-community-server-5.7.24-1.el6.x86_64.rpm
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.31-1.el6.x86_64.rpm-bundle.tar
wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-server-5.7.31-1.el6.x86_64.rpm
yum repolist all | grep mysql
cat /etc/yum.repos.d/mysql-community.repo
Note: MySQL 5.7 is currently in development. For use at your own risk.
Please read with sub pages: https://dev.mysql.com/doc/relnotes/mysql/5.7/en/
[mysql57-community-dmr]
name=MySQL 5.7 Community Server Development Milestone Release
baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/6/$basearch/
enabled=【1】
gpgcheck=1
gpgkey=file:/etc/pki/rpm-gpg/RPM-GPG-KEY-mysql
vim /etc/yum.repos.d/mysql-community.repo
yum repolist all | grep mysql
yum install mysql-community-server-5.7.24-1.el6.x86_64.rpm
tar --help
/usr/software/mysql/5.7.24
tar -tvf mysql-5.7.24-1.el6.x86_64.rpm-bundle.tar
tar -xf mysql-5.7.24-1.el6.x86_64.rpm-bundle.tar
yum 【upgrade】 【mysql-*】
阶段2:
Error:1146 - Table 'performance schema.session variables' doesn't exist
sudo su【否则可能无法生成升级报告文件】
mysql_upgrade -u root -p --force
service mysqld restart
mysql - Table 'performance_schema.session_variables' doesn't exist - Stack Overflow
https://stackoverflow.com/questions/36746677/table-performance-schema-session-variables-doesnt-exist
连接mysql报错Table ‘performance_schema.session_variables’-阿里云开发者社区
https://developer.aliyun.com/article/689012
rpm下载地址:
MySQL :: Download MySQL Community Server
https://dev.mysql.com/downloads/mysql/5.7.html
MySQL :: Download MySQL Community Server (Archived Versions)
https://downloads.mysql.com/archives/community/
官网文档:
mysql5.7安装升级 - 浩然&开心 - 博客园
https://www.cnblogs.com/dahaoran/p/12913031.html
MySQL升级 - iVictor - 博客园
https://www.cnblogs.com/ivictor/p/5776349.html
MySQL 5.6 升级到MySQL 5.7-云栖社区-阿里云
https://yq.aliyun.com/articles/543336
MySQL dump进行5.6迁移升级到5.7踩过的坑_布偶猫爸爸的博客-CSDN博客_5.6迁移到5.7有什么坑
https://blog.csdn.net/qq_21108311/article/details/89881183
MySQL 5.6升级至MySQL 5.7--------版本升级最佳实战 - MySQL数据库 - 亿速云
https://www.yisu.com/zixun/34154.html
参考文章:
mysql5.7安装升级 - 浩然&开心 - 博客园
https://www.cnblogs.com/dahaoran/p/12913031.html
MySQL升级 - iVictor - 博客园
https://www.cnblogs.com/ivictor/p/5776349.html
MySQL 5.6 升级到MySQL 5.7-云栖社区-阿里云
https://yq.aliyun.com/articles/543336
MySQL dump进行5.6迁移升级到5.7踩过的坑_布偶猫爸爸的博客-CSDN博客_5.6迁移到5.7有什么坑
https://blog.csdn.net/qq_21108311/article/details/89881183
MySQL 5.6升级至MySQL 5.7--------版本升级最佳实战 - MySQL数据库 - 亿速云
https://www.yisu.com/zixun/34154.html