Disable ManageMasterUserPassword

Question

For a MySQL database, I turned on "Manage master credentials" in AWS console. I decided to use a "master password" instead. When I uncheck the ManageMasterUserPassword and assign a "master password", AWS console gives me an error , "You can't specify MasterUserPassword for an instance with ManageMasterUserPassword enabled."

Answer

Hello,

I understand that you tried to reset the master user password but it failed with error below:

"You can't specify MasterUserPassword for an instance with ManageMasterUserPassword enabled."

This message indicates that you cannot update the master user manually as it is being managed by secret manager.

I would suggest you to try to disable master credentials management via console or CLI. Please find more information below.

To modify the master user credential management in secret manager of your DB instance, you can use the following steps on console or the CLI command:

AWS Console:

> Open the Amazon RDS console.
	> Select Databases.
	> Select the RDS/Aurora DB instance, and then choose Modify.
	> Uncheck the box: "Manage master credentials in AWS Secrets Manager in Credential settings"
        > Save the settings

Via CLI:
    	
    	aws rds modify-db-cluster \
    	--db-cluster-identifier dbidentifier\
    	--no-manage-master-user-password \
        --master-user-password "NewPassword"
    	--apply-immediately

Disable ManageMasterUserPassword

相關內容