MySQL Upgrade from 5.6 to 5.7 to 8.0

Share via:

Dear Readers,

In this article, we will see the following MySQL Upgrade from 5.6 to 5.7 to 8.0

1. Logging to AWS Account

First, we need to AWS Console page by using below link.

https://aws.amazon.com/console/

Click on sign in to Console button.

Logging to aws account

Login using username & password and click on sign in.

Enter to AWS Management Console

We can see the AWS Management Console Dashboard.

Go to Services, under the compute module click EC2 service to open.

2. Launch MySQL Server

Go to Services, under the compute module click EC2 service to open.

We can launch Windows Server by using below link.

Launch Linux EC2 Instance

We can see the windows server has been launched successfully.

3. Connect to Linux EC2 Instance Using Putty

We can connect putty by using below link.

Connect to MySQL Server Using Putty

4. Switch to root user

5. Install Server updates

6. Install wget package 

6. Install MySQL 5.6 

We can install MySQL 5.6 by using below link.

Install MySQL 5.6

7. Upgrade MySQL from 5.6 to 5.7
Check the Status of MySQL 

Stop the Service of MySQL 5.6

Check the Status of MySQL 

Take Backup of MySQL Database 5.6

Remove Binaries of MySQL 5.6

Download Binaries of MySQL 5.7 (RPM)

Install Binareis of MySQL 5.7 (RPM)

Install MySQL 5.7

Check Version of MySQL

Start the Service of MySQL

Check the Status of MySQL 

Connect to MySQL 5.7 Database 

Check the version of MySQL 5.7 Database

Upgrading the MySQL 5.7 Database

Setting the root Password 

This command enables you to improve the security of your MySQL installation in the following ways:
👉 You can set a password for root accounts.
👉 You can remove root accounts that are accessible from outside the local host.
👉 You can remove anonymous-user accounts.
👉 You can remove the test database, which by default can be accessed by anonymous users.

Connect to MySQL 5.7 Database 

Check the version of MySQL 5.7 Database

8. Upgrade MySQL from 5.7 to 8.0
Check the Status of MySQL 

Install MySQL Shell 

Check the migration issues of Database data 

Note : please resolve the issues before the upgrade
when you do upgrading the software binaries but not touch the data

Stop the Service of MySQL 5.6

Check the Status of MySQL 

Remove Binaries of MySQL 5.7

Download Binaries of MySQL 8.0 (RPM)

Install Binareis of MySQL 8.0 (RPM)

Install MySQL 8.0

Check Version of MySQL

Start the Service of MySQL

Check the Status of MySQL 

Connect to MySQL 8.0 Database 

Check the version of MySQL 8.0 Database

Setting the root Password 

This command enables you to improve the security of your MySQL installation in the following ways:
👉 You can set a password for root accounts.
👉 You can remove root accounts that are accessible from outside the local host.
👉 You can remove anonymous-user accounts.
👉 You can remove the test database, which by default can be accessed by anonymous users.

Connect to MySQL 8.0 Database 

Check the version of MySQL 8.0 Database

Thank you for giving your valuable time to read the above information. Please click here to subscribe for further updates

KTEXPERTS is always active on below social media platforms.

 

Facebook : https://www.facebook.com/ktexperts/
LinkedIn : https://www.linkedin.com/company/ktexperts/
Twitter : https://twitter.com/ktexpertsadmin
YouTube : https://www.youtube.com/c/ktexperts
Instagram : https://www.instagram.com/knowledgesharingplatform

Follow Me
Ramesh’s Linkedin : Ramesh Atchala

Share via:
Note: Please test scripts in Non Prod before trying in Production.
1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
Loading...

Add Comment