Change Database Passwords

Please complete the following steps to change the passwords for the Designer Cloud Powered by Trifacta platform users of the Alteryx databases.

Change in Database Server

PostgreSQL

1. If you have not done so already, switch to the Postgres user and launch psql:
   
   

   sudo su - postgres
   psql

2. For each database, change the default password. Default usernames are listed for each database. Please modify the command if you are using different roles and insert a more secure password for <new_pwd>:
   
   

   ALTER ROLE trifacta WITH PASSWORD '<new_pwd>';
   ALTER ROLE trifacta-activiti WITH PASSWORD '<new_pwd>';
   ALTER ROLE trifactatimebasedtriggerservice with PASSWORD '<new_pwd>';
   ALTER ROLE trifactaschedulingservice with PASSWORD '<new_pwd>';

3. Exit psql:
   
   

   \q
   exit

MySQL

1. If you have not done so already, switch to the MySQL user and launch:
   
   

   sudo su - mysql
   mysql

2. For each database, change the default password. Default usernames are listed for each database. Please modify the command if you are using different roles and insert a more secure password for <new_pwd>:
   
   

   NOTE: In MySQL, the dash is a forbidden character in usernames. Please use underscores instead.

   ALTER USER 'trifacta'@'localhost' IDENTIFIED BY '<new_pwd>';
   ALTER USER 'trifacta-activiti'@'localhost' IDENTIFIED BY '<new_pwd>';
   ALTER USER 'trifactatimebasedtriggerservice'@'localhost' IDENTIFIED BY '<new_pwd>';
   ALTER USER 'trifactaschedulingservice'@'localhost' IDENTIFIED BY '<new_pwd>';

3. Exit:

   \q
   exit

Change in Alteryx configuration

1. Below are the username and password properties for each database. You can apply this change through the Admin Settings Page (recommended) or trifacta-conf.json. For more information, see Platform Configuration Methods. Please review and update as needed: 

   1. Alteryx database: 

      "webapp.db.username" = "<user>",
      "webapp.db.password" = "<pwd>",

   2. Jobs database: 

      "batch-job-runner.db.username" = "<user>",
      "batch-job-runner.db.password" = "<pwd>",

   3. Scheduling database: 

      "scheduling-service.database.user" = "<user>",
      "scheduling-service.password.password" = "<pwd>",

   4. Time-based trigger database: 

      "time-based-trigger-service.database.user" = "<user>",
      "time-based-trigger-service.database.password" = "<pwd>",

2. Save your changes and restart the platform.