Which solution will meet this requirement?
Use MySQL native database authentication.
Use AWS Secrets Manager to rotate the credentials.
Use AWS Identity and Access Management (IAM) database authentication.
Use AWS Systems Manager Parameter Store for authentication.
Explanations:
MySQL native authentication requires fixed credentials and does not support the use of temporary credentials.
AWS Secrets Manager helps with credential rotation but does not enforce temporary credentials for database access.
AWS IAM database authentication allows users to connect to the RDS MySQL database using temporary credentials generated by IAM.
AWS Systems Manager Parameter Store is used for storing configuration data, but it does not support enforcing temporary credentials for database authentication.
I judge that the answer is:
Use AWS Identity and Access Management (IAM) database authentication.