• See also: IAM Database Connection Information

Step 1: Authenticate to the database where the password needs to be reset. 

Step 2: Run the following SQL command, replacing [username goes here] with your user account name and replacing [password goes here] with your new password:

ALTER USER [username goes here] IDENTIFIED BY "[password goes here]";

Example: To reset the user scott password to tiger you would run:
ALTER USER scott IDENTIFIED BY "tiger";

Step 3: Success! Your password has been reset.

Step 4: Update your password within your application to match. 

NOTE: If you are resetting your password in PHEXPP or PHEXPT, you need to make sure you are resetting your password in both databases (PHEXPP1 and PHEXPP2, or PHEXPT1 and PHEXPT2), there is no replication between databases.

If you run into issues or have any questions about this process, please contact mstsupport@doit.wisc.edu.