Change the Controller Database Root User Password

By default, the password for the controller user of the Aurora database used in your Splunk AppDynamics deployment is controller.

To change the Controller Database root user password:

  1. Log in to the RDS instance as root:
    1. ./mysql -u root -h <rds-aurora-endpoint> -P 3388 -p
  2. Use MySQL to run the commands:
    1. To specify the Controller Database, enter: use mysql;
    2. To reload the MySQL grant tables, enter: FLUSH PRIVILEGES;
    3. To determine your MySQL version, enter: select version();
    4. If you are using MySQL version 5.5, to configure the new password for the root user, enter: update mysql.user set password=password('<new-password-here>') where user like 'controller%';
    5. If you are using MySQL version 5.7, to configure the new password for the root user, enter: update mysql.user set authentication_string=password('<new-password-here>') where user like 'controller%';
    6. To reload the MySQL grant tables, enter: FLUSH PRIVILEGES;
    7. To exit MySQL, enter: quit
  3. Update the controller-db-password alias with the new Controller DB password in Glassfish:
    cd <controller_home>/appserver/glassfish/bin
./asadmin update-password-alias controller-db-password
  4. Restart the Controller AppServer for the changes to take effect: 
    cd <controller_home>/bin
./controller.sh stop-appserver
./controller.sh start-appserver
  5. Verify the change in asadmin: 
    cd <controller_home>/appserver/glassfish/bin
./asadmin ping-connection-pool controller_mysql_pool