简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

How to upgrade mysql to 5.7

王林
Release： 2020-10-13 15:29:24
Original
2447 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：
mysql
source：php.cn
Previous article：Can indexes be deleted in mysql? Next article：How to modify the information in the table in mysql view
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 Articles by Author
Latest Issues
How to list data in a section by ID using while loop in PHP? I have a mysql table with these columns: series_id, series_color, product_name In the outp...
From 2023-11-17 20:03:03
0
1
290
Using triggers and constraints to limit the number of records in MySQL I have a table called BFFs that stores user IDs and best friends' user IDs, and I want to ...
From 2023-11-14 13:35:02
0
4
434
Resolving django.db.utils.NotSupportedError error in Django I'm getting an error when running a project in Django. The problem is unfortunately I upgr...
From 2023-11-14 11:59:20
0
1
246
Retrieve MySql rows with the same column value Let us consider the following table - IDScore19521003884100573 I am a complete SQL noob, b...
From 2023-11-10 21:53:39
0
2
331
How to publish SQLite database data to an online MySQL database in Flutter? How to sync offline SQLite to MySQL online database in Flutter? Any suggestions?
From 2023-11-10 12:36:40
0
2
247
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
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！