Update the Database User Password Configured to the Platform Analytics Repository

Windows
Linux

The database user password of the Platform Analytics Repository is provided during the installation and configuration steps. However, you can modify the Platform Analytics Repository user password any time after the initial installation and configuration.

To change the password, you need:

One environment with MicroStrategy and Platform Analytics fully installed and configured. For more information, see Installing Platform Analytics.
Access to the machine (Linux or Windows) where Platform Analytics was installed and configured.

How to Update the Database User Password

Open Windows Services and locate MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. Right-click each service and select Stop.
In the Platform Analytics directory, located in C:\Program Files (x86)\MicroStrategy\Platform Analytics\, open the bin folder.
Run the following script:
Copy
```
platform-analytics-encryptor.bat
```
Enter your new database user password to generate a new encrypted password.

Copy the encrypted password.

Copy


C:\Program Files (x86)\MicroStrategy\Platform Analytics\bin>platform-analytics-encryptor.bat
Please type the password below to generate the encrypted password for Platform Analytics:
the secret i will always keep
Encrypted password generated:
7YX+l/9HOr6DPpT0AiEVNzsnug==,x7F8IezkCtLjFFdX
Press any key to continue . . .

Still in the Platform Analytics directory, open the conf folder.
Open the PAConsumerConfig.yaml file and update the whPasswd field with the encrypted password.
One space is needed after whPasswd:
For example:
whPasswd: 7YX+l/9HOr6DPpT0AiEVNzsnug==,x7F8IezkCtLjFFdX
Save the file.
Open Windows Services and start MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer.
Open Command Manager and connect to the Project Source that contains the Platform Analytics project.
In the PASSWORD field, enter the new unencrypted password.
Copy
```
ALTER DBLOGIN "Platform Analytics Login" LOGIN  "myPAWarehouseUser" PASSWORD "the secret i will always keep";
```
You do not need to enter the encrypted password. The password you entered will be encrypted when stored in the metadata.
Execute the command. Your password is updated for the Platform Analytics project.

The database user password of the Platform Analytics Repository is provided during the installation and configuration steps. However, you can modify the Platform Analytics Repository password any time after the initial installation and configuration.

To change the password, you need:

One environment with MicroStrategy and Platform Analytics fully installed and configured. For more information, see Installing Platform Analytics.
Access to the machine (Linux or Windows) where Platform Analytics was installed and configured.

How to Update the Database User Password

In the Platform Analytics directory, located in /opt/MicroStrategy/PlatformAnalytics, open the bin folder.
Run the following commands to stop MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer:
Copy
```
./platform-analytics-consumer.sh stop
./platform-analytics-usher-lookup-producer.sh stop
```
In the same folder, run the following command to generate an encrypted password for the MySQL database user:
Copy
```
[user@your-PA-machine bin]#./platform-analytics-encryptor.sh
```
Enter your new database user password to generate a new encrypted password.

Copy the encrypted password.

Copy

C:\Program Files (x86)\MicroStrategy\Platform Analytics\bin>platform-analytics-encryptor.bat
Please type the password below to generate the encrypted password for Platform Analytics:
the secret i will always keep
Encrypted password generated:
7YX+l/9HOr6DPpT0AiEVNzsnug==,x7F8IezkCtLjFFdX
Press any key to continue . . .

In the Platform Analytics directory, open the conf folder.
Edit the PAConsumerConfig.yaml file and update the whPasswd field with the encrypted password.

One space is needed after whPasswd:

For example:

whPasswd: 7YX+l/9HOr6DPpT0AiEVNzsnug==,x7F8IezkCtLjFFdX
Save the file.
In the Platform Analytics directory, open the bin folder and run the following commands to start MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer:
Copy
```
./platform-analytics-consumer.sh start
./platform-analytics-usher-lookup-producer.sh start
```
Open Command Manager and connect to the Project Source that contains the Platform Analytics project.
In the PASSWORD field, enter the new unencrypted password.
Copy
```
ALTER DBLOGIN "Platform Analytics Login" LOGIN  "myPAWarehouseUser" PASSWORD "the secret i will always keep";
```
You do not need to enter the encrypted password. The password you entered will be encrypted when stored in the metadata.
Execute the command. Your password is updated for the Platform Analytics project.