A software company uses an Amazon RDS for MySQL Multi-AZ DB instance as a data store for its critical applications.During an application upgrade process, a database specialist runs a custom SQL script that accidentally removes some of the default permissions of the master user.
What is the MOST operationally efficient way to restore the default permissions of the master user?
Modify the DB instance and set a new master user password.
Use AWS Secrets Manager to modify the master user password and restart the DB instance.
Create a new master user for the DB instance.
Review the IAM user that owns the DB instance, and add missing permissions.
I would say the answer is:
Modify the DB instance and set a new master user password.