How to connect to AWS MySQL / MariaDB RDS or EC2 Database from MySQL WorkBench
In this article, we are going to explain how to connect to AWS MySQL/MariaDB RDS or MySQL/MariaDB database running inside an EC2 machine from MySQL Workbench. Workbench can be installed on your local laptop/desktop.
What is MySQL WorkBench
MySQL Workbench is an official graphical tool to manage the MySQL database. Using workbench you can take the backup, create database, user and grant role, monitor database health and many more other activities.
You can download it from www.mysql.com
Prerequisites
| RDS: Valid Endpoint name
EC2: Machine hostname /IP MySQL DB Port: 3306 (Default) Credentials: Username and Password of the database user Network: VPC and security group setup to reach till database from outside over the Internet or using the AWS network if MySQL Workbench is installed inside the AWS infrastructure. |
#1. Open MySQL Workbench
#2. Add new connection under ‘MySQL Connections‘ and click on ‘+‘
#3. Enter connection details
HostName: xyz.est1.rds.amazonaws.com or Public IP of ec2/RDS endpoint.
Port: 3306
Username:
And hit ‘Test Connection’ once you see ‘successful message’ you are done.
Let me know if you see any issues or have any questions.
Please like our Facebook page and share this post in your network.
Read More
How to Become Oracle apps DBA?
What does DBA mean?
150 Oracle DBA Interview Questions
Top 5 Future Technologies for Database Administrators (DBA) to learn in 2020
Top 5 Software Technology Trends in 2020 List
