How do I reset the account password in Amazon Redshift?

Last updated: 2020-09-22

I'm trying to reset my account password in Amazon Redshift. How do I change the account password?

Resolution

Reset a standard user account password

To change the password for a standard user account, perform the following steps:

Note: You must have superuser(or adminuser) account credentials.

1.    Sign in to the AWS Management Console using superuser credentials.

2.    Open the Amazon Redshift console.

3.    Run the ALTER USER command and enter your desired password:

ALTER USER username password ‘password’;(

Note: Passwords for standard user accounts must be changed using the ALTER USER command.

4.    Log back in to Amazon Redshift using the new account password to verify the updated password.

Reset the superuser account password using the Amazon Redshift console

To change the superuser (or adminuser) password using the Amazon Redshift console, perform the following steps:

1.    Sign in to the AWS Management Console.

2.    Open the Amazon Redshift console.

3.    Choose Clusters.

4.    Select your Amazon Redshift cluster.

5.    Choose Actions.

6.    From the drop-down menu, choose Change master user password.

7.    Enter a new user password.

8.    Choose Save. Your admin account password is now modified.

9.    Log back in to Amazon Redshift using the new account password to verify the updated password.

Note: The password change is asynchronous, and is applied immediately. You don't need to restart Amazon Redshift.

Reset the superuser account password using the AWS Command Line Interface (AWS CLI)

1.    Configure the AWS CLI.

2.    Run the modify-cluster command and enter your desired password:

aws redshift modify-cluster –cluster-identifier <identifier-for-the cluster> –master-user-password ‘master-password’;

Note: If you receive an error while running your AWS CLI command, be sure that you’re using the most recent version of the AWS CLI.

For more information about the modify-cluster API, see ModifyCluster.

3.    Log back in to Amazon Redshift using the new account password to verify the updated password.


Did this article help?


Do you need billing or technical support?