Change RDS Admin Username

Question

Is there a way to change the default admin username of a SQL 2017 RDS databases. From what I can see, this is not possible and we will have to create a new RDS instance/cluster. If so, can we restore from a snapshot, or does that pull in the old admin username that we're trying to get away from? What's the right path to resolve this?

Riku_Kobayashi · Accepted Answer

Hello.

As you know, once you create RDS, you cannot change the master username.(As of November 2024, the master username cannot be changed.)  
The master username cannot be changed even when restoring from a snapshot.  
Therefore, I think it is necessary to create a user with the same privileges or create a new RDS and migrate the data.  
https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.MasterAccounts.html  
> When you create a new DB instance, the default master user that you use gets certain privileges for that DB instance. You can't change the master user name after the DB instance is created.

Change RDS Admin Username

Add your answer

Relevant content