postgresql - Rename the Amazon RDS master username -


changing password done through console. there way change master username after creation on rds postgresql? if so, how?

you can't change username. can check following links describe how change master password , if amazon adds ability change username find there:

try find @ aws cli rds:

 modify-db-instance --db-instance-identifier <value> --master-user-password (string) 

--master-user-password (string)

the new password db instance master user. can printable ascii character except "/", """, or "@".

changing parameter not result in outage , change asynchronously applied possible. between time of request , completion of request, masteruserpassword element exists in pendingmodifiedvalues element of operation response. default: uses existing setting

constraints: must 8 41 alphanumeric characters (mysql, mariadb, , amazon aurora), 8 30 alphanumeric characters (oracle), or 8 128 alphanumeric characters (sql server).

the amazon rds command line interface (cli) has been deprecated. instead, use aws cli rds.

via aws management console, choose instance need reset password for, click ‘modify’ choose new master password.

if don’t want use aws console, can use rds-modify-db-instance command (as per amazon’s documentation rds) reset directly, given aws command line tools: rds-modify-db-instance instance-name --master-user-password examplepassword


Comments

Popular posts from this blog

css - SVG using textPath a symbol not rendering in Firefox -

Java 8 + Maven Javadoc plugin: Error fetching URL -

node.js - How to abort query on demand using Neo4j drivers -