mysql升级5.7.22_mysql 5.6升级到5.7.22

下载对应的包

wget  https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.22-linux-glibc2.12-x86_64.tar

备份数据库(至少备份mysql)

innobackupex -uxbackup  -u root -p ocm123  --no-timestamp /data/backup/

手动在备一次

mv mysql mysql_bak

建立软连接

ln -s   /root/mysql-5.7.22-linux-glibc2.12-x86_64   mysql

查看mysql_upgrade 帮助文档 -s, --upgrade-system-tables Only upgrade the system tables, do not try to upgrade the data.

/etc/init.d/mysqld start

mysql_upgrade -s

/etc/init.d/mysqld restart

到此升级完成，注意观察error日志

原文：https://www.cnblogs.com/omsql/p/9241366.html