How to Upgrade MySql 5.7 to MySql 8 Using RPM?

STEP BY STEP UPGRADE MYSQL 5.7 TO MYSQL 8.0 USING RPM PACKAGE 

Download RPM package for Mysql 8.0 for os specific from mysql official website. Click Here to download 8.0 RPM 

STEP-1: Extract the rpm tar file using tar -xvf

[root@ctpdb1 MY8.0]# tar -xvf mysql-8.0.21-1.el6.x86_64.rpm-bundle.tar

mysql-community-libs-compat-8.0.21-1.el6.x86_64.rpm

mysql-community-test-8.0.21-1.el6.x86_64.rpm

mysql-community-client-8.0.21-1.el6.x86_64.rpm

mysql-community-server-8.0.21-1.el6.x86_64.rpm

mysql-community-devel-8.0.21-1.el6.x86_64.rpm

mysql-community-libs-8.0.21-1.el6.x86_64.rpm

mysql-community-common-8.0.21-1.el6.x86_64.rpm

STEP-2: Stop Mysql Service for mysql 5.7

[root@ctpdb1 MY8.0]# service mysqld stop

mysqld is stopped

STEP-3: Go to mysql extracted folder and install rpm package using below command, if you are trying separate rpm installation then you will get package conflict error. check this post about RPM Package Fail due to conflicts with mysql package Solution

[root@ctpdb1 MY8.0]# yum install mysql-community-{server,client,common,libs-compat,libs}-* mysql-8.*.

Loaded plugins: refresh-packagekit, security, ulninfo

Setting up Install Process

======================

Updating:

mysql-community-client x86_64 8.0.21-1.el6 /mysql-community-client-8.0.21-1.el6.x86_64 228 M

mysql-community-common x86_64 8.0.21-1.el6 /mysql-community-common-8.0.21-1.el6.x86_64 8.8 M

mysql-community-libs x86_64 8.0.21-1.el6 /mysql-community-libs-8.0.21-1.el6.x86_64 22 M

mysql-community-libs-compat x86_64 8.0.21-1.el6 /mysql-community-libs-compat-8.0.21-1.el6.x86_64 5.7 M

mysql-community-server x86_64 8.0.21-1.el6 /mysql-community-server-8.0.21-1.el6.x86_64 2.3 G

Transaction Summary

========================

Upgrade 5 Package(s)

Total size: 2.5 G

Is this ok [y/N]: y

Downloading Packages:

Running rpm_check_debug

Running Transaction Test

Transaction Test Succeeded

Running Transaction

Updating : mysql-community-common-8.0.21-1.el6.x86_64 1/10

Updating : mysql-community-libs-8.0.21-1.el6.x86_64 2/10

Updating : mysql-community-client-8.0.21-1.el6.x86_64 3/10

Updating : mysql-community-server-8.0.21-1.el6.x86_64 4/10

Updating : mysql-community-libs-compat-8.0.21-1.el6.x86_64 5/10

Cleanup : mysql-community-server-5.7.31-1.el6.x86_64 6/10

Cleanup : mysql-community-client-5.7.31-1.el6.x86_64 7/10

Cleanup : mysql-community-libs-compat-5.7.31-1.el6.x86_64 8/10

Cleanup : mysql-community-libs-5.7.31-1.el6.x86_64 9/10

Cleanup : mysql-community-common-5.7.31-1.el6.x86_64 10/10

Verifying : mysql-community-server-8.0.21-1.el6.x86_64 1/10

Verifying : mysql-community-client-8.0.21-1.el6.x86_64 2/10

Verifying : mysql-community-libs-compat-8.0.21-1.el6.x86_64 3/10

Verifying : mysql-community-libs-8.0.21-1.el6.x86_64 4/10

Verifying : mysql-community-common-8.0.21-1.el6.x86_64 5/10

Verifying : mysql-community-libs-5.7.31-1.el6.x86_64 6/10

Verifying : mysql-community-server-5.7.31-1.el6.x86_64 7/10

Verifying : mysql-community-client-5.7.31-1.el6.x86_64 8/10

Verifying : mysql-community-libs-compat-5.7.31-1.el6.x86_64 9/10

Verifying : mysql-community-common-5.7.31-1.el6.x86_64 10/10

Updated:

mysql-community-client.x86_64 0:8.0.21-1.el6mysql-community-common.x86_64 0:8.0.21-1.el6 mysql-community-libs.x86_64 0:8.0.21-1.el6

mysql-community-libs-compat.x86_64 0:8.0.21-1.el6 mysql-community-server.x86_64 0:8.0.21-1.el6

Complete!

STEP-4: Start Mysql 8.0

[root@ctpdb1 MY8.0]# service mysqld start

Starting mysqld: [ OK ]

Up-gradation complete now you can login with MySQL 8.0.

[root@ctpdb1 MY8.0]# mysql -uroot -p

Enter password:

Welcome to the MySQL monitor. Commands end with ; or \g.

Your MySQL connection id is 12

Server version: 8.0.21 MySQL Community Server - GPL

Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its

affiliates. Other names may be trademarks of their respective

owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

 Please share your comment on below box.

SHARE SHARE SHARE

pavan

• 
• 
• 
• 
•