Page tree

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 2 Current »

Outdated release! Latest docs are Release 8.2: Change Database Passwords for MySQL

   

You should change the passwords for the Trifacta® databases immediately after installing the software.

Please complete the following steps to change the passwords for the Trifacta platform users of the Trifacta databases.

Change in Database Server

  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>';
    ALTER USER 'trifactaconfigurationservice'@'localhost' IDENTIFIED BY '<new_pwd>';

  3. Exit:

    \q
    exit

Change in Trifacta 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. Trifacta database: 

      "webapp.database.username" = "<user>",
      "webapp.database.password" = "<pwd>",
    2. Jobs database: 

      "batch-job-runner.database.username" = "<user>",
      "batch-job-runner.database.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>",
    5. Configuration Service database:

      "configuration-service.database.user" = "<user>",
      "configuration-service.database.password" = "<pwd>",
    6. Artifact Storage Service database:

      "artifact-storage-service.database.user" = "<user>",
      "artifact-storage-service.database.password" = "<pwd>",
  2. Save your changes and restart the platform.

  • No labels

This page has no comments.