Installation of MySQL 8.0.21 On RHEL Using Generic Binaries in AWS Cloud

Share via:

Dear Readers,

In this article, we will see the following Installation of MySQL 8.0.21 On RHEL Using Generic Binaries in AWS Cloud .

Steps to Follow :
  1. Logging to AWS Account
  2. Launch MySQL EC2 Instance
  3. Connect to Linux EC2 Instance by Using Putty
  4. Switch to root user
  5. Install Server Updates
  6. Install wget package
  7. Download MySQL Distribution (tar)
  8. Install 8.0 Binaries (rpm)
  9. Install MySQL Server 8.0
  10. Start the Service of MySQL
  11. Get the temporary Password
  12. Setting the root Password
  13. Connect to MySQL Database

 

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 EC2 Instance

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

We can launch MySQL EC2 Instance by using below link.

Launch Linux EC2 Instance

We can see the MySQL EC2 Instance has been launched successfully.

3. Connect to Linux EC2 Instance Using Putty

We can connect putty by using below link.

Connect to EC2 Instance Using Putty

Go inside the Linux Server Terminal.

4. Switch to root user

5. Install Server updates

6. Install wget package 

7. Download MySQL Distribution (Tar)

Go to MySQL official website by using below link.

https://dev.mysql.com/downloads/mysql/

Go to MySQL Community Downloads and click on MySQL Community Server.

Click on Archives.

Select Product Version, Operating System and Operating System Version.

Select TAR file and copy the link address by giving the right click.

Go to server terminal and download the MySQL Distribution

8. Exract the Distribution (TAR)

Copy the Extracted distribution (tar.gz) to “/usr/local” 

Go inside the directory “/usr/local” and check the distribution

8. Extract the Distrobuton (tar.gz)

The tar command creates a directory named mysql-8.0.21-el7-x86_64.

9. Install MySQL Dependencies

Search libaio

Install libaio

Install ncurses-compat-libs

10. Create a mysql User and Group 

Create a Group “mysql”

Create a User “mysql”

11. Create soft link to the installation directory

12. Go inside the mysql directory and initialize the MySQL

Make Directory “mysql-files”

Change Ownership for the directory “mysql-files”

Change the permission for the diretory “mysql-files”

Initialize MySQL 
The command also creates a temporary root password.

13. Create SSL certificate and key files and RSA key-pair files

14. Start the MySQL Server Using mysqld_safe

Copy the init script from support-files to /etc/init.d

15. Export the path

Check the Version of MySQL

Start and stop the MySQL server
Stop the MySQL Server

Check the status of MySQL Server

Start the MySQL Server

16. 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.

17. Connect to MySQL Database

Check the version of MySQL 

 

 

Thank you for giving your valuable time to read the above information.
Follow us on 
Website  www.ktexperts.com
Facebook Page KTexperts
Linkedin Page : KT EXPERTS

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