AWS account access with sign in and full permissions to operate AWS Secrets Manager and Amazon RDS
Create a secret for an AWS database and configure it to rotate on a schedule. Trigger one rotation manually, and then confirm that the new version of the secret continues to provide access.
Step 1: Set Up a Test Database
In this step, you create a test database in Amazon Relational Database Service (Amazon RDS)
Step 2: Create Secret
Next, use the Secrets Manager console to create the secret and populate it with the initial user name and password for the MySQL database. Test the secret by using the returned credentials to sign in to the database.
Step 3: Validate the Initial Secret
In step 3, Use the new secret to test the credentials and ensure that we can use them to connect to the database.
Step 4: Configure Rotation for the Secret
In step 4, Enable rotation for the secret and perform the initial rotation.
Step 5: Verify Successful Rotation
In this step, after the initial rotation completes, repeat the validation steps to show that the new credentials generated during rotation continue to allow us to access the database.
Step 6: Clean Up
In the final step, we remove the Amazon RDS database instance and the secret to avoid incurring any unnecessary costs.