AWS Aurora MySql connector user guide

Owned by EazyDI Main Account
Mar 21, 2024
4 min read

AWS Aurora MySQL connector user guide

  1. Log in to your AWS account console.

  2. On the search bar type RDS and select the RDS service

 

Once you are in the RDS service page, Click on Databases tab on the side bar to see all your databases.

 

Select your Aurora MySql database

 

To Connect your Database to EazyDi app using the STANDARD authentication, you will need:

Host

Port

Username

Database name

Password

 

Click on your Aurora MySQL instance, You will see the “ENDPOINT” which will be your HOST. And the PORT number in the “Connectivity and security tab”

 

To Get your DATABASE NAME, go to the “CONFIGURATION” Tab and there you will see your DBNAME. The MASTER USERNAME which you will use as your USERNAME will be on the main cluster’s Configuration tab

 

Get Username: Go to your main cluster and click the Configuration tab

 

Once you have all your credentials, you can now connect your database to EazyDi app. Create a connection. Select the AWS RDS MySQL connector

 

Input all the required connection properties that you got from Step 6 and 7. The Host, Port, DBNAME, Master Username. The password is the one you set when creating your database. *Note that you will input the DBNAME in the “Database” field

 

 

Once you have created a connection, you can now select a table from the list of connection objects

 

To connect your database to EazyDi app using IAM authentication, you will need

 

Host

Port

Username

Access Key

Secret Key

Region

 

 

IAM AUTHENTICATION

First, make sure that your database allows IAM Authentication. Do Pre requisites steps 1 through 3 then Navigate to your main cluster’s Configuration Tab. Confirm that IAM DB authentication is Enabled

 

To allow an IAM user or role to connect to your database instance or database cluster, you must create an IAM policy. After that, attach the policy to an IAM user or role. For more information, see Create and Attach Your First Customer Managed Policy.

You construct the policy document from the following four key pieces of data:

  • The Region of your cluster

  • Your AWS account number

  • The database resource ID or the cluster resource ID

  • Your database user name

For RDS and AURORA:

After you have your IAM user created and your IAM policy attached to the user, you must create a database user with the same name as you specified in the policy. In this policy It’s all dbusers. Grant all privileges to the user you created using these statements

 

CREATE USER mydbuser IDENTIFIED WITH AWSAuthenticationPlugin AS 'RDS';

GRANT ALL ON `%`.* TO mydbuser@`%`;

 

 

 

Go back to dashboard and search for AWS RDS MySQL and click connect

 

Click add new connection

 

Choose Authentication as IAM authentication and fill in the required fields. The username used should be the created in step 3, add the access key and secret key of the IAM user that has the policy created in step 2, then click create connection

 

Verify that credentials and setup are correct by checking if connection object lists will show similar to stanard authentication