-- After  "root" password for Synchrony database is changes , how can we change the username and password in SynchronyDatabaseManager.properties file as all the information in that file is in encrypted form.

Please find below the steps required to change the SynchronyDatabaseManager.properties file located at <SynchronyHome >\Synchrony_Database\properties

If you have an active installation of Composer the procedure is mentioned below  :

1) To retrieve the encrypted value for a password,use the encryptpass.cmd tool available under the Composer/composer folder.

2) In composer.properties file located at <SynchronyHome>\Composer\composer\properties make the changes mentioned below :(Kindly take the back up of this file before making any changes.)

dataSource.password.format = clear( Change this field from "AES128" to "clear")

dataSource.url.format = clear (  Change this field  from "AES128" to "clear")

dataSource.driver=com.mysql.jdbc.Driver

dataSource.password=<new password>

dataSource.url=IshRwcn51ytrC5rqBb/selMUMXCOqXCCbVtVftOTHjDsCOw7i4dnw1rb1abzMeXOG6kkeBFns7bk\r\nYqz/3evw6itQwtqw1EH2vc08OlEMTdJlei1fri9FobNUcXlm7TG5\r\n

dataSource.user=Composer

dataSource.type=MYSQL_database

Save the file .

3) Open the cmd prompt and use the command encryptpass DES at the location "<SynchronyHome>\Composer\composer\properties"

4) Open the file composer.properties after running the command and copy the encrypted password and paste it in "SynchronyDatabaseManager.properties" file

5) Start the database. Database will start successfully.

6) Replace the original composer.properties file at the location :<SynchronyHome>\Composer\composer\properties