How to install MySQL 5.7 on Amazon ec2

Question

How am I able to install MySQL 5.7 in the cloud on Amazon EC2?

Most of the Amazon Machine Instances (AMIs) that I see either lack any MySQL server or possess an older version such as MySQL Server 5.5

I want to use the latest and greatest.

Answer 1

Considering you have a running Red Hat Enterprise Linux (RHEL) instance, I'll provide the steps to install MySQL 8.0 in it as you want to use the latest and 8.0 is the latest.

Step 1: Install wget

Go to /home/ec2-user

sudo yum install wget

Step 2: Use wget to download the MySQL Yum repository.

wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm

Step 3: Now, install the mysql locally

sudo yum localinstall mysql80-community-release-el7-3.noarch.rpm

Step 4: Install MySQL community server

sudo yum install mysql-community-server

Step 5: Confirm your MySQL service status

sudo service mysqld status

That's it! 

Since you are facing issues while working on Amazon EC2 that's why the article on AWS EC2 will surely come in handy for you.

You can learn in-depth about SQL statements, queries and become proficient in SQL queries by enrolling in our industry-recognized SQL course.

Comments

getting mysqld unrecognized service. Please help to solve this