Mysql – the rdsadmin user and should I care

amazon-rdsamazon-web-servicesMySQL

I've inherited control of an AWS MySQL RDS instance. I'm curious to know what the 'rdsadmin' user is and whether I should know the password for this or whether this is purely for use by the Amazon Web Console.

Best Answer

This is Amazon's own user that is used by Amazon to perform updates, run backups and do other maintenance tasks. That said, Amazon's support should be able to advise you.

In general, you don't need to (and should not) know the password.

Related Solutions

Amazon S3 – How to Get the Size of an Amazon S3 Bucket

The AWS CLI now supports the --query parameter which takes a JMESPath expressions.

This means you can sum the size values given by list-objects using sum(Contents[].Size) and count like length(Contents[]).

This can be be run using the official AWS CLI as below and was introduced in Feb 2014

 aws s3api list-objects --bucket BUCKETNAME --output json --query "[sum(Contents[].Size), length(Contents[])]"

The best JDBC connection URI for AWS RDS instances

From http://aws.amazon.com/rds/faqs/#36

During certain types of planned maintenance, or in the unlikely event of DB Instance failure or Availability Zone failure, Amazon RDS will automatically failover to the standby so that you can resume database writes and reads as soon as the standby is promoted. Since the name record for your DB Instance remains the same, you application can resume database operation without the need for manual administrative intervention. With Multi-AZ deployments, replication is transparent: you do not interact directly with the standby

As long as you have your RDS instance in multi-AZ, you are good with the jdbc url of the RDS instance FQDN.

Best Answer

Related Solutions

Amazon S3 – How to Get the Size of an Amazon S3 Bucket

The best JDBC connection URI for AWS RDS instances

Related Topic