Thomas Step

← Blog

I recently launched a Slack app to help with channel bloat! Simply installing it would help me out a bunch. I have 2/10 installations required to submit my app to the Slack Marketplace. Thanks for helping me reach that goal.

Installing the MySQL CLI on an EC2 Instance

Edit: Installing the MySQL CLI on Amazon Linux 2023 is further down the page.

The other day I spun up an RDS cluster in a VPC and wanted to connect to it to make sure everything looked correctly configured. However, since I put the cluster in a private subnet and only allowed connections from the VPC, I was not able to connect from my desktop. The solution I decided to go for was spinning up a small EC2 instance, SSHing into the EC2 instance, and connecting to my database through the CLI. Unfortunately, the default AMI does not come with the mysql CLI installed. Here is how I installed it.

sudo yum install -y https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm
sudo yum install -y mysql-community-client
# Run the following line if you get a GPG error and then run the previous line again
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
mysql -u MY_USER -p`MY_PASSWORD` -h MY_HOST -P 3306

After installing and connecting to my database, I was able to confirm that everything was up an running.

Amazon Linux 2023

sudo dnf update -y
sudo dnf install mariadb105-server
mysql -u MY_USER -p`MY_PASSWORD` -h MY_HOST -P 3306
Categories: aws | ops | databases