How to upgrade mysql to 5.7

Method to upgrade mysql to 5.7: 1. Download the rpm package corresponding to the system and version; 2. Execute the rpm command to install; 3. Execute the [mysql_upgrade -u root -p --force] command to upgrade the database .

1. Download the MySQL5.7rpm package from the official website (4 pieces)

(Recommended tutorial: mysql video tutorial)

Enter the MySQL community download page, the default is the latest version of MySQL 8.0

Select the corresponding system and version

Download these 4 packages

##2. Install in the following order

rpm -ivh mysql-community-common-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.26-1.el7.x86_64.rpm 
rpm -ivh mysql-community-client-5.7.26-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.26-1.el7.x86_64.rpm

3. End the operation

When connecting remotely When the following error occurs, you need to upgrade the database: mysql_upgrade -u root -p --force

If the following error occurs during the execution of mysql_upgrade, it means that it is caused by permissions. Just add: skip-grant-tables to .cnf and delete this line after the execution is completed

Related recommendations:

mysql tutorial

The above is the detailed content of How to upgrade mysql to 5.7. For more information, please follow other related articles on the PHP Chinese website!