How do I reset the Controller root user password?

[Erin]

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 iconand 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:

• User Management
• Controller Data and Backups
• Manage Users and Groups Overview

[Edgar.Chavarro]

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]

@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]

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

[Samson.Kolge]

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]

@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.