3. Connect to EC2

Set up EC2 connection

Wait until DB status become available.

Go to RDS - Databases - Select database - Actions - Set up EC2 connection.

Select EC2 you want to connect.

Two security group will be made and connect each other.

Check DB endpoint

I've got username, password and DB name. I need url and port for making DB connection.

Go to RDS - Databases - Select one - Connectivity & security tab.

There is an endpoint & port.

Install mariadb in EC2 to use mysql client

Go to EC2 terminal then install mariadb. I will not use this mariadb server but I need a mysql client within the package.

sudo dnf install mariadb105.x86_64 -y

Make a connection to RDB. Only inside EC2 that I setup connection can access to it.

mysql -u admin -p --host our-company-lunch-db.c0u48asuozzj.ap-northeast-2.rds.amazonaws.com --port 3306

Check variables for character set and collation. I can see the custom parameter group applied.

show variables where variable_name like 'c%';