Page tree

Outdated release! Latest docs are Release 8.7: 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
  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 'trifactaactiviti'@'localhost' IDENTIFIED BY '<new_pwd>';
    ALTER USER 'trifactaschedulingservice'@'localhost' IDENTIFIED BY '<new_pwd>';
    ALTER USER 'trifactatimebasedtriggerservice'@'localhost' IDENTIFIED BY '<new_pwd>';
    ALTER USER 'trifactaconfigurationservice'@'localhost' IDENTIFIED BY '<new_pwd>';
    ALTER USER 'trifactasartifactstorageservice'@'localhost' IDENTIFIED BY '<new_pwd>';
    ALTER USER 'trifactajobmetadataservice'@'localhost' IDENTIFIED BY '<new_pwd>';
  3. Exit:


Change in Trifacta configuration

  1. You can apply this change through the Admin Settings Page (recommended) or

    . For more information, see Platform Configuration Methods.

  2. Modify the user and password properties for any of the following databases:

    Database NameParameter area

    Trifacta database

    Jobs database
    Scheduling database
    Time-based Trigger database
    Configuration Service database

    Artifact Storage Service database

    Job Metadata Service databasejob-metadata-service.database.*

    For more information, see Database Parameter Reference.

  3. Save your changes and restart the platform.

This page has no comments.