Question 19747 in Amazon Web Sevices Question posted in
The official Amazon Web Services documentation can be found here.

IAM authentication to connect with any SQL client to Amazon RDS for MySQL

I can connect to the MySQL RDS database using IAM authentication from the SQL command line tool. But the same I need to achieve connections with SQL clients like DBeaver or some other clients. I don’t have the provision of passing tokens in SQL client.

This document explains connecting RDS using MySQL workbench/j but I am unable to download the MySQL workbench/j due to a forbidden error. https://aws.amazon.com/blogs/database/use-iam-authentication-to-connect-with-sql-workbenchj-to-amazon-aurora-mysql-or-amazon-rds-for-mysql/

Could someone help me in connecting RDS using IAM authentication from an SQL client?

Tags:

2

Answers


  1. 0

    If you’re going to use DBeaver
    The proper connection details :

    • Server Host: Endpoint address
    • Port: 3306
    • Database: DB name
    • User name: Database master username
    • Password: Database master password

    1
    2

    2
    1

    Login or Signup to reply.
  2. 0

    In fact you could use the aws rds command to generate each time a new token to use as your password to authenticate the database. But since you want to do it with deaver, looks like its available (https://dbeaver.com/docs/wiki/AWS-Credentials/) but only in Enterprise edition (not the community edition)

    enter image description here

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search