Reset Root User Password

If you have lost the Splunk 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 in to the Controller database of the Controller;
    • For Windows: controller.bat login-db
    • For Linux: sh controller.sh login-db
    You will see a MySQL prompt.
  3. After running the script, you will be prompted to enter a password. Enter the root password for the Controller database.
  4. From the MySQL prompt, enter the following SQL command to get root user details: 
    select * from user where name='root' \G;
  5. 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.
  6. Restart the AppserverNo Content found for /db/organizations/splunk/repositories/appdonprem-26_6_0/AppDynamics/documents/content/on_premises/c_start_or_stop_the_controller.dita.
For information on setting the database root user password, see Controller Data and Backups.