So, to connect to your Amazon RDS for MySQL instance using IAM authentication, you must use AWSAuthenticationPlugin. With Amazon RDS for MySQL, IAM authentication is handled by AWSAuthenticationPlugin. Then, choose the Configuration tab to view the resource ID.įor more information about the elements listed in the example IAM policy, see Creating and using an IAM policy for IAM database access. To find a DB instance's resource ID, choose the Resource tab in the AWS Management Console. Note: Replace db-user-name with the database account user that's associated with the IAM authentication.Īdditionally, make sure that you're using the correct resource ID (instead of only specifying the ARN).

' arn:aws:rds-db:region:account-id:dbuser:(DbiResourceId or DbClusterResourceId)/db-user-name' The rds-db:connect action allows connections to the DB instance. To successfully connect to your Amazon RDS for MySQL instance using IAM database authentication, you must have access to the rds-db:connect action. For more information, see Using the Apply Immediately setting. This action can cause an extended outage for your Amazon RDS for MySQL instance. Note: If you choose Apply Immediately when updating your cluster configuration settings, all pending modifications are applied immediately (instead of during a maintenance window). Then, choose Password and IAM database authentication and Continue to update your configuration settings. From the Amazon RDS console, you can modify the instance by choosing Database Authentication. Review the configuration settings for your Amazon RDS for MySQL cluster, and make sure that IAM authentication is turned off. Resolution IAM authentication is turned offīy default, IAM authentication is turned off. Last login: Thu Nov 3 07:35:06 on ttys000Īdministrators-MacBook-Pro:~ admin$ sudo dpkg-reconfigure mysql-server-5.If you can't connect to an Amazon RDS for MySQL or Aurora DB instance using IAM authentication, then check for the following reasons: Originally, I got the below messages:ĮRROR 1045: Access denied for user: (UsingĪnd was told I should make the password changes from my terminal. I am new to SQL and have read various forum tips in my attempt to reconfigure the SQL password to connect from Navicat to the SQL server.

Navicat 1045