Ravindra BagaleCourses & study guides मराठी Track your progress

Ravi Sir's Cards › AWS

Connect and run a query

What is a VPC: your own private network inside one AWS Region, example ThreeTierVpc 10.0.0.0/16.

Connect and run a query A cluster that nobody queries teaches nothing — and security groups often block you. Allow the client SG or CloudShell path to port 3306/5432. Use mysql/psql against the cluster endpoint with SSL as required. From EC2 or notes: mysql -h CLUSTER_ENDPOINT -u admin -p → CREATE DATABASE lab; SELECT 1; Query returns 1; a lab table insert is visible on a reconnect.
Connect and run a query · Download PNG
Read card text

What this card says

Why do we need it?

A cluster that nobody queries teaches nothing — and security groups often block you.

What is it?

Allow the client SG or CloudShell path to port 3306/5432. Use mysql/psql against the cluster endpoint with SSL as required.

3306

How to do it

From EC2 or notes: mysql -h CLUSTER_ENDPOINT -u admin -p → CREATE DATABASE lab; SELECT 1;

Example

Query returns 1; a lab table insert is visible on a reconnect.

See all AWS revision cards