5.6升级到5.7

准备工作

• 已经编译好的5.7
• 温柔关闭mysql

开始升级

1.确认下版本

# mysql -V
mysql Ver 14.14 Distrib 5.6.36, for linux-glibc2.5 (x86_64) using  EditLine wrapper

1. 删除软链

   # cd /usr/local
   # unlink mysql
   

2. 新建软链

   # ln -s mysql57 mysql
   

3. 启动服务

   # /etc/init.d/mysql start
   

4. 升级 此时启动日志，会发现里面有很多很多的ERROR，都是有关于系统表结构的，所以执行升级

   # mysql_upgrade -s
   The --upgrade-system-tables option was used, databases won't be touched.
   Checking if update is needed.
   Checking server version.
   Running queries to upgrade MySQL server.
   Upgrading the sys schema.
   Upgrade process completed successfully.
   Checking if update is needed.