mysql-community-server-5.7.24 & 5.7.31 (5.6.35 升级到 5.7.24)
阶段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
作者:任国强
来源链接:https://www.cnblogs.com/rgqancy/p/13361269.html
版权声明:
1、JavaClub(https://www.javaclub.cn)以学习交流为目的,由作者投稿、网友推荐和小编整理收藏优秀的IT技术及相关内容,包括但不限于文字、图片、音频、视频、软件、程序等,其均来自互联网,本站不享有版权,版权归原作者所有。
2、本站提供的内容仅用于个人学习、研究或欣赏,以及其他非商业性或非盈利性用途,但同时应遵守著作权法及其他相关法律的规定,不得侵犯相关权利人及本网站的合法权利。
3、本网站内容原作者如不愿意在本网站刊登内容,请及时通知本站(javaclubcn@163.com),我们将第一时间核实后及时予以删除。