This lab walks you through the creation and testing of an Amazon Aurora database. We will create an Aurora MySQL database and test the connection.
Duration: 90 minutes
AWS Region: US East (N. Virginia) us-east-1
Launching Lab Environment
Create Aurora Database Instance.
Create an RDS Database Instance
Connecting to Amazon Aurora MySQL RDS Database on a DB Instance.
Connecting from a Windows Machine
Execute Database Operations for Windows users
Connecting from a local Linux/iOS Machine
Execute Database Operations for Mac/Linux users
Validation of the lab
Deleting AWS Resources
Windows users need to download and install MySQL Workbench
MySQL Workbench will be used for connecting to the database and executing SQL commands.
Linux Users need to install MySQL. Run the following command to install MySQL on your local machine:
brew install MySQL
Note: If you do not have a brew, install brew, and then execute the command above.