Shulou(Shulou.com)06/01 Report--

MySQL upgrade process from version 5. 6 to version 5. 7 binary upgrade process 1. Introduction here because the original version is 5.6, I will not repeat the installation process of 5.6. the directory of the original database 5.6-basedir=/usr/local/mysql # base directory is a soft chain, pointing to mysql-5.6.28-linux-glibc2.5-x86_64 ln-s mysql-5.6.28-linux-glibc2.5-x86_64 mysql--datadir=/data/mysql-- defaults-file=/etc/my.cnf 2. Shut down mysqladmin-uroot-p shutdown 3. Redirect mysql to version 5.7 cd / usr/local unlink mysql or mv mysql mysql56.bak tar-zxvf mysql-5.7.12-linux-glibc2.5-x86_64.tar.gz ln-s mysql-5.7.12-linux-glibc2.5-x86_64 mysql

Or the following will do, mv mysql-5.7.12-linux-glibc2.5-x86_64 mysql 4. Grant mysql user rights to the directory chown-R mysql.mysql mysql # at this time, the application version of MySQL has been upgraded

# you can upgrade the mysql version of the current system without any changes

# Note: at this time, only the application upgrade has been completed, and the system table is still version 5. 6. Using the original data directory and configuration file, the startup database mysqld_safe-defaults-file=/etc/my.cnf-user=mysql & can be started successfully, but as you can see in the error log, there are many error and warning 6. The operation parameter-s for upgrade upgrade must be added, which means that only the system table is updated,-s: upgrade-system-tables

# if you do not add-s, the tables of all libraries will be rebuilt in a manner of 5.7. Do not do this online.

# because database binaries are compatible, there is no need to upgrade. / mysql/bin/mysql_upgrade-p-s Enter password: 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.

7. Access the database and do a check

When mysql-uroot-p enters the database, you can see that with more sys libraries, more users have updated the mysql.sys mysql.user table, no password columns, and the test library is retained. These are the differences between mysql5.7 and 5.6.There are new parameters in detail 5.7. in order to avoid further trouble, restart the database. At this time, you can see the error log and check the current version.

Mysql-V

If you upgrade in this way, the switch of ssl in 5.7will not be turned on, because it is not enabled by default in 5.6.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.