Linux – amazon linux 2 ami – aws – How to install thesql in Amazon Linux 2

amazon ec2amazon-linuxlinuxMySQL

I am trying to install mysql in amazon linux 2 ami and am not able to do it.

sudo yum install mysql56-server -> doesn't work
amazon-linux-extras list -> doesn't list mysql

I do not want mariadb since I have more exposure to mysql (even if both are the same)

Best Answer

I got the answer myself. Follow the below steps:

sudo wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
sudo yum localinstall mysql57-community-release-el7-11.noarch.rpm 
sudo yum install mysql-community-server
systemctl start mysqld.service

The key is to add the source repo and then install since Amazon Linux 2 doesn't have the default repos in place already.

Related Solutions

Postgresql – how to install scripts like pg_lsclusters on a Amazon AWS Linux AMI

This commands (pg_) comes from package postgresql-common, which is Debian specific. I think it's question to PostgreSQL's binary distribution maintainers (Amazon). I know it's not solution, but (probably) you can still use low level commands such as pg_ctl (pg_ctlcluster), initdb (pg_createcluster) etc. but of course it's not as handy as pg_.

How to install mariadb on amazon linux

I was able to install the MariaDB 5.5 CentOS repository list (created 2016-05-09 04:06 UTC).

Create the following file:

sudo vi /etc/yum.repos.d/maria.repo

Add the following contents to the file and save:

[mariadb]
name = MariaDB
baseurl = http://yum.mariadb.org/5.5/centos6-amd64
gpgkey=https://yum.mariadb.org/RPM-GPG-KEY-MariaDB
gpgcheck=1

Then run the following commands:

sudo yum install -y MariaDB-server MariaDB-client
sudo /etc/init.d/mysql start

You should be all set. Run mysql -u root to log in.

You can secure MariaDB with the following command:

sudo mysql_secure_installation

More information: https://mariadb.com/kb/en/mariadb/mysql_secure_installation/

Fortunately, I was trying to install MariaDB on Amazon Linux, myself. Just now I got it to work as above.

Best Answer

Related Solutions

Postgresql – how to install scripts like pg_lsclusters on a Amazon AWS Linux AMI

How to install mariadb on amazon linux

Related Topic