Manage the Enterprise Console Database User Password

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;
```
Note:
If the Enterprise Console is running MySQL 5.7 or later, use the ALTER command instead of the password() function to update user passwords as follows, as the password() function has been deprecated in MySQL 5.7 and newer versions:
```
ALTER USER 'platformadmin'@'localhost' IDENTIFIED BY '<new_password_here>'; 
```
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.