cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Erin
AppDynamics Team (Retired)

You can change the root user password from the AppDynamics Administration Console page.

 

Note: If using the "Forgot Password" link, the emailed token will expire four hours after it is sent. The duration of this token is not configurable.

 

To change the root user password:

  1. In a browser, log in to the administration console as described in Access the Administration Console.
  2. Click the gear iconGearand choose My Settings.
  3. Click Edit > Change Password.
  4. Type the new password for the root user in the New Password and Repeat New Password fields.
  5. Click Save

 

Note: Logging in to the Administration Console requires you to have the root user password. If you do not have the root user password and need to reset it, follow these instructions:

 

To reset root user password: 

If you have lost the AppDynamics root user password for your installation and need to reset it, follow these steps:

 

  1. From the command line, change to the Controller's bin directory. For example, on Linux:

    cd <controller_home>/bin
  2. Use the following script to log into the Controller database of the Controller;
    • For Windows: controller.bat login-db
    • For Linux: sh controller.sh login-db
    You should see a MySQL prompt.
  3. At the MySQL prompt, enter the following SQL command to get root user details:

    select * from user where name='root' \G;
  4. Use the following SQL command to change the password: 

    update user set encrypted_password = sha1('<NewPassword>') where name = 'root';

    The hash for the password will be upgraded to PBKDF2 when you log in.

 

For information on setting the database root user password, see Controller Data and Backups

 

 

Relevant Links:

Comments
Edgar.Chavarro
Adventurer

Hi There,

 

Thank you for your reply.

 

I tried to do that, but the Database service is like stopped, I try to start but it is impossible.

 

 

Jeanie.Kedia
AppDynamics Team (Retired)

@Edgar.Chavarro sorry to hear it didn't work, your next best bet is to open a support ticket. https://help.appdynamics.com/ 

Let us know how it goes. 

Edgar.Chavarro
Adventurer

@jeanie.kedia, thank you, I will do that.

Samson.Kolge
Voyager

Hi All,

I am getting below message:

# bin/controller.sh login-db
[INFO] Path to mysql is not defined in system environment (MYSQL_BIN). Using mysql from /opt/appdynamics/controller/db/bin

[INFO] Mysql configuration file is not defined in system environment (AD_DB_CNF). Using mysql configuration file: /opt/appdynamics/controller/db/db.cnf

[INFO] Mysql datadir is /opt/appdynamics/controller/db/data
Logging into the controller database
Enter password:

 

I have lost the db password.

 

There is no .rootpw file in the db folder as well. How do I reset this? Please advise!

 

Jeanie.Kedia
AppDynamics Team (Retired)

@Samson.Kolge there isn't a quick answer for this, need Support to investigate perhaps for you. Let me know how it goes, please private message me if you are not able to open a support ticket and can assist further. 

Version history
Last update:
‎10-03-2018 04:36 PM
Updated by:
Contributors