Change the platformAdmin Database User Password

To change the platformAdmin.databasePassword, follow these steps:

Note: Use the application ID that owns the Splunk AppDynamics On-Premises platform installation when running the commands.

Start the Enterprise Console, if it is not already running. Run the following command, replacing <EC_home> before running the command:
```
<EC_home>/platform/platform-admin/bin: ./platform-admin.sh start-platform-admin
```
Navigate to the <EC_home>/platform/mysql/bin directory.
Log in to the database as the root user by running the following command:
```
./mysql -u root -p -h 127.0.0.1 -P 3377 --protocol=TCP
```

Execute the following queries, replacing <new_password_here> before executing the query.

update mysql.user set authentication_string=password('<new_password_here>') where user like 'platformadmin%'; flush privileges; quit;

Verify the login by running the following command in the <EC_home>/Platform/mysql/bin directory:
```
./mysql -u platformadmin -p -P 3377 -h 127.0.0.1
```
Navigate to the <EC_home>/platform/platform-admin/bin directory.
Run the command below to encrypt the new password that was set for platformadmin in step 4.
```
./platform-admin.sh encrypt --text '<new_password_here>'
```
Note: In Windows environments, single quotes (') are not supported on the command line. Windows users should wrap the <new_password_here> option in double quotes (").

Take note of the encrypted password.
Navigate to the <EC_home>/Platform/platform-admin/conf directory.
Backup the PlatformAdminApplication.yml file.
Using a text editor, such as vi, open the PlatformAdminApplication.yml file and find the encrypted password: line in the database: section.
Update the encrypted password, replacing the text after the password: entry with the password noted after step 7 and save the changes.
Stop the Enterprise Console by running the following command in the <EC_home>/Platform/platform-admin/bin directory:
```
./platform-admin.sh stop-platform-admin
```
Start the Enterprise Console by running the following command in the <EC_home>/Platform/platform-admin/bin directory:
```
./platform-admin.sh start-platform-admin
```
Validate that the Enterprise Console started successfully.

Documentation