mysql5.6 升级 mysql5.7

yum remove mysql-*

[root@localhost ~]# wget http://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

[root@localhost ~]# yum localinstall mysql80-community-release-el7-3.noarch.rpm

[root@localhost ~]# vim /etc/yum.repos.d/mysql-community.repo

......

# Enable to use MySQL 5.7

[mysql57-community]

name=MySQL 5.7 Community Server

baseurl=http://repo.mysql.com/yum/mysql-5.7-community/el/7/$basearch/

gpgcheck=1

gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-mysql

......

......

InnoDB: Table mysql/innodb_table_stats has length mismatch in the column name table_name.  Please run mysql_upgrade

......

[root@localhost ~]# mysql_upgrade -uroot

Checking if update is needed.

Checking server version.

Running queries to upgrade MySQL server.

Checking system database.

mysql.columns_priv                                 OK

mysql.db                                           OK

mysql.engine_cost                                  OK

mysql.event                                        OK

mysql.func                                         OK

mysql.general_log                                  OK

mysql.gtid_executed                                OK

mysql.help_category                                OK

mysql.help_keyword                                 OK

mysql.help_relation                                OK

mysql.help_topic                                   OK

mysql.innodb_index_stats                           OK

mysql.innodb_table_stats                           OK

mysql.ndb_binlog_index                             OK

mysql.plugin                                       OK

mysql.proc                                         OK

mysql.procs_priv                                   OK

mysql.proxies_priv                                 OK

mysql.server_cost                                  OK

mysql.servers                                      OK

mysql.slave_master_info                            OK

mysql.slave_relay_log_info                         OK

mysql.slave_worker_info                            OK

mysql.slow_log                                     OK

mysql.tables_priv                                  OK

mysql.time_zone                                    OK

mysql.time_zone_leap_second                        OK

mysql.time_zone_name                               OK

mysql.time_zone_transition                         OK

mysql.time_zone_transition_type                    OK

mysql.user                                         OK

Upgrading the sys schema.

Checking databases.

azkaban.active_executing_flows                     OK

azkaban.active_sla                                 OK

azkaban.execution_flows                            OK

azkaban.execution_jobs                             OK

azkaban.execution_logs                             OK

azkaban.project_events                             OK

azkaban.project_files                              OK

azkaban.project_flows                              OK

azkaban.project_permissions                        OK

azkaban.project_properties                         OK

azkaban.project_versions                           OK

azkaban.projects                                   OK

azkaban.properties                                 OK

azkaban.schedules                                  OK

azkaban.triggers                                   OK

sys.sys_config                                     OK

Upgrade process completed successfully.

Checking if update is needed.