MySQL Upgrade steps

Before upgrading, please do a good job of data backup

1. Unzip TAR-ZXVF mysql-5.7.9-linux-glibc2.5-x86_64.tar.gz

2. Close mysql5.6.23 database service mysqld stop

3. Put the 5.7.9 version under the default directory

MV Mysql-5.7.9-linux-glibc2.5-x86_64/usr/local/mysql

4. Modify the permissions under/usr/local/mysql/data

Chown-r Mysql.mysql/usr/local/mysql/data

5. Cp/usr/local/mysql/support-files/mysql.server/etc/init.d/mysqld

6. Modify the configuration file/etc/my.cnf

expire-logs-day=10--->expire-logs-days=10

7. Start Service mysqld Start

8. Error logging and processing

Starting the database after upgrade prompts for no initialization prompt [

ERROR] Native table ' Performance_schema '. ' Memory_summary_by_user_by_event_name ' has the wrong structure

[ERROR] Native table ' Performance_schema '. Events_transactions_summary_by_account_by_event_name ' has the wrong structure

Use the following command to resolve

/usr/local/mysql/bin/mysql_upgrade-u root-p

9. To facilitate management, you can add environment variables to modify the PATH variable

Vim/etc/profile

Export path= $PATH:/usr/local/mysql/bin

10. Change the password

# VI/ETC/MY.CNF

Add a sentence to the paragraph in [mysqld]: Skip-grant-tables

This article from "Running" blog, declined reprint!

MySQL Upgrade steps