How to upgrade mysql to 5.7

王林
Release: 2020-10-13 15:29:24
Original
2526 people have browsed it

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 .

How to upgrade mysql to 5.7

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

How to upgrade mysql to 5.7

Select the corresponding system and version

How to upgrade mysql to 5.7

Download these 4 packages

How to upgrade mysql to 5.7

##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
Copy after login

3. End the operation

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

How to upgrade mysql to 5.7

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

How to upgrade mysql to 5.7

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!

Related labels:
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn:Public welfare online PHP training,Help PHP learners grow quickly!