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

This article mainly introduces the operation steps of upgrading mysql to 5.7, which has certain reference value, and friends who need it can refer to it. I hope you all have a lot to gain after reading this article. Let's take a look at it together.

How 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 command [mysql_upgrade -u root -p --force] to upgrade the database.

I. Download MySQL 5.7rpm package from official website (4 pcs)

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

Select the appropriate system and version

Download these 4 packages

II. Install in the following order

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

III. End Operation

When the following error occurs in the remote connection, the database needs to be upgraded: mysql_upgrade -u root -p --force

If the following error occurs during the execution of mysql_upgrade, it indicates that it is caused by permissions. Add skip-grant-tables to my.cnf and skip it. Remove this line after execution is complete.

Thank you for reading this article carefully. I hope Xiaobian will share the steps to upgrade mysql to 5.7. At the same time, I hope everyone will support you a lot. Pay attention to the industry information channel. If you encounter problems, find detailed solutions waiting for you to learn!

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.